Profile Picture

Add one day to a datetime

Posted By Bob Smith 11 Years Ago
Author
Message
Bob Smith
Posted 11 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: 11 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 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Last Week
Posts: 3,054, Visits: 4,009
Try this expression:

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


Best Regards,
Nevron Support Team



Bob Smith
Posted 11 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: 11 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