I am having trouble with the DateAdd function in SSRS 2005. I want the user to enter a parameter for the number of days. I want to filter a date range in the dataset with the result set.
= DATEADD(d, 0, '02/28/2011') works fine.
= DATEADD(d, @Days, '02/28/2011') gives me this error:
Error Source: System.Data
Error Message: Failed to convert parameter value from a Decimal to a DateTime.
I have tried setting the parameter data type to string, int, bool, datetime, and double and nothing works.