Add one day to a datetime


https://www.nevron.com/Forum/Topic7799.aspx 		Print Topic | Close Window

By Bob Smith - 11 Years Ago

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?
By Nevron Support - 11 Years Ago
Try this expression:

=MAXVAR(DATETIME(Fields!End_Date)) + TIMESPAN("1.0:0:0.0")
By Bob Smith - 11 Years Ago

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