Syntax for Date Range Parameter in Report Editor

Question

Greetings, 
 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.

Markus Weiss-Ehlers · Accepted Answer

If your parameter is specified as range you will implicitly get 2 parameters defining the start and the end that you can use in your queries. 
 So instead of @parametername, you can use @parametername Start and @parmetername End in your SQL query or where-clause. 
 AND startdate between @parameternameStart and @parameternameEnd 
 These 2 parameters also appear in the dictionary of the report definition. 
 One sample for this would be the report User account operations (VI_UNS_Account_Operations) that does not demonstrate the SQL usage but the auto-created parameters in the report definition.

Syntax for Date Range Parameter in Report Editor

Top Replies