Error querying between dates with parameters
Posted on 2012-04-04
I know, the title is hard to explain but I will try....
In SSRS 2005 I have a lenghty query that has paramters for a @startdate and an @enddate. I use this in the query in the where statement like
eventtime between @startdate and @enddate
If I run the query and get promted for the the @startdate and @enddate but it then fails with an error:
An error occurered while executing the query.
Conversion failed when converting the nvarchar value '04/01/2012' to data type int.
The query works fine if I declare the @startdate and @enddate and then
set the @startdate and @enddate with the same values in the query. But if I declare the then I don't get prompted.