Profile Picture

Add one day to a datetime

Posted By Bob Smith 7 Years Ago
Author
Message
Bob Smith
Posted 7 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 69, Visits: 1

I have the X axis set up on a chart to show Max: "=MAXVAR(DATETIME(Fields!End_Date))" and Min: "=MINVAR(DATETIME(Fields!Start_Date))"

I would like to add 1 day to the "=MAXVAR(DATETIME(Fields!End_Date))" statement. This will allow me to show a full, complete month at the end of my chart (I structured my data this way).

How can I add one day to the max end date value so that my range will encompass my full data set?



Nevron Support
Posted 7 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)Supreme Being (3,954 reputation)

Group: Forum Members
Last Active: Last Week
Posts: 2,888, Visits: 3,074
Try this expression:

=MAXVAR(DATETIME(Fields!End_Date)) + TIMESPAN("1.0:0:0.0")


Best Regards,
Nevron Support Team



Bob Smith
Posted 7 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 69, Visits: 1

What is the syntax for the "Timspan" function? I can't find the "Timespan" function in the Nevron SharePoint Vision documentation. Thanks!





Similar Topics


Reading This Topic