Problem with Reporting services - creatign a report Errors in SQL Statement

Hiya,

I am going around in circles here - I am trying to do a sql statement that takes the date that is greater than the Start date I choose and less than / equal to the finish date. I wrote the attached statement and it keeps failling please tell me where I am going wrong.

Under the parameters both parameters are set to Date / Time as type.

Thanks
SQL.JPG
LVL 5
mickinoz2005Asked:
Who is Participating?
 
mickinoz2005Connect With a Mentor Author Commented:
I deleted all parameters and re created them, there is a bug in SQL reporting that keeps appearing and the only solution seems to be to delete the parameters and recreate them.
0
 
LindaClaesCommented:
It's more readable if you would say AND date_entered BETWEEN @StartDate AND @FinishDate
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.