Converting a datetime and adding an additional day to parameter value
Hi,
I have the following in an SSRS report:
(CONVERT(datetime, CONVERT(varchar(10), date_column, 101)) = DATEADD(d, @startdate, 1))
The date_column is a datetime datatype in the database.
I would like the date_column to display the date picked from parameter @startdate + 1 day.
When I use the above sql, it gives me an error: argument data type nvarchar is invalid for argument 2 of dateadd function
Can anyone advise me how add 1 day to the @startdate parameter?
Thanks
August 16th, 2011 12:26pm
It should be
DATEADD
(d,
1,
@startdate).
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2011 12:39pm