|
I have a date field that is a decimal data type which I converted to datetime. When I use dateadd with the converted data type in SSMS 2005 it works but when I put this in SSRS 2008 I get the following error.
This works fine in SSRS 2008. Any suggestions?
(comments are locked)
|
|
Instead of @BeginDate + 7, try DATEADD(dd,7,@BeginDate) Thanks, I wll give that a try.,
May 06 '12 at 04:15 PM
scarney
(comments are locked)
|


Your 2 queries are different. Your 2005 script has + 7.
SSMS vs SSRS ? Where are you putting this in SSRS?
I copied the wrong query, both should be the first one. Where I'm having the problem is when I try to add days (+7). The query works fine in SSRS when I don't try to add days.
Thanks.