Add one day to a datetime

Author	Message
Bob Smith	Bob Smith posted 12 Years Ago Topic Details
Group: Forum Members 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?
	Reply Like 0
Nevron Support	Nevron Support posted 12 Years Ago Post Details
Group: Administrators Posts: 3.1K, Visits: 4.2K	Try this expression: =MAXVAR(DATETIME(Fields!End_Date)) + TIMESPAN("1.0:0:0.0") Best Regards, Nevron Support Team
	Reply Like 0
Bob Smith	Bob Smith posted 12 Years Ago Post Details
Group: Forum Members 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!
	Reply Like 0