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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics