Reports using SQL Schema Designer with fixed date

[TomW]

I've been trying to create a report using the SQL Schema Designer to return requests after a particular date (in this case 2018-09-01), but unfortunately I am not having any luck.

Could anyone offer any advice on how I could do this?

[Steven Boardman]

Hi @TomW there should be a few options

1. You can use a user prompt to choose the date you want the report to run something like below:

So when you preview the data or run the report you will be prompted for the date / time 

 

2. if you wanted to have a report which dynamically looked at date ranges you could do something like below:

 

3. You could use the variable picker to inject a date range as below:

 

Hope this helps

Steve

 

 

 

[TomW]

Thanks again Steve. I'll look at doing this instead!