We have enhanced the functionality in the date prompts that you see on most of the reports in Learn. This functionality now gives you complete control over the date ranges you select in your reports.
You can now specify exactly how many days from today that you want to filter in your report. Today is day=0. So if you want to limit the date range from 10 days ago to today then you can specify '-10' for the start date and '0' for the end date (which is today).
You can also mix and match what you put into the date prompts. So you could specify a fixed date as a start date and your own dynamic date as the end date, or you can use the pre-built dates such as 'Last 30 days'.
How do I add the dynamic date prompts to my report?
If you want to add the dynamic date prompts onto a report then you can find them in the 'Prompts and Dates' folder in the Learn.unx universe.
To use them you need to decide which date object you wish to apply the date range filter to. For example if you wish to restrict the 'Course Start Date' in your reports then do the following:
- Add the 'Course Start Date' object to your report query and select 'Between' as the operator.
- Click the 'Define filter type' button next to the blank box and select 'Object from this query'.
- Select 'Dynamic Start Date Prompt' from the 'Prompts and Dates' folder.
- Repeat for the next blank box and select 'Dynamic End Date Prompt' for the end date of your 'Between' filter.
- Run the report. You will now see your start and end date prompts at the top of your prompt window. The default value is 'Last 30 days: start' and 'Last 30 days: end'. You can now change these values to be whatever you wish as described at the start of this article.