I am not able to locate the correct syntax when using a data parameter where the Range = Yes for the Report Editor. I created a date parameter for my report and set it to Range = Yes but I am receiving errors when executing it because the syntax is not correct. I was able to create 2 separate parameters with @startdate and @enddate and then input this into my data source query in the report so the code is as follows: AND startdate between @startdate and @enddate.
Question: What is the correct syntax in my SQL when I user a date Parameter where the Range = Yes? I would like to use this functionality in my report to set a date range or should I just use the two separate date parameters with an @startdate and @enddate?
Thank you in advance.