• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

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


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.

1 Solution
It's more readable if you would say AND date_entered BETWEEN @StartDate AND @FinishDate
mickinoz2005Author 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.
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now