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.
Instead of @BeginDate + 7, try DATEADD(dd,7,@BeginDate)
answered May 04 '12 at 10:58 AM
Grant Fritchey ♦♦