TomW Posted October 18, 2018 Share Posted October 18, 2018 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? Link to comment Share on other sites More sharing options...
Steven Boardman Posted October 19, 2018 Share Posted October 19, 2018 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 Link to comment Share on other sites More sharing options...
TomW Posted October 19, 2018 Author Share Posted October 19, 2018 Thanks again Steve. I'll look at doing this instead! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now