Learn - Specify custom dynamic date ranges in Date Prompts

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:

1. Add the 'Course Start Date' object to your report query and select 'Between' as the operator.
2. Click the 'Define filter type' button next to the blank box and select 'Object from this query'.
   
   
   
3. Select 'Dynamic Start Date Prompt' from the 'Prompts and Dates' folder.
   
   
   
4. Repeat for the next blank box and select 'Dynamic End Date Prompt' for the end date of your 'Between' filter.
   
   
   
5. 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.
   

Get deeper learning in The Academy

Take a tour of the top standard reports in 'Learn LMS: top standard reports and why', for best practice hints and tips to support your learning.

View 'Reporting for beginners' to learn more about reports.

View 'Report building skills' to build your skills. You can also book a space on one of our live ‘Ask me anything: reporting!’ events with our reporting experts. Your opportunity to ask any report questions you have to our experts! 

Have you completed the administrator learning pathway for Learn? Click here to start your learning and to get your trained administrator certificate on completion.

The Academy is your forever free learning hub for Kallidus products including live events, eLearning videos, and more. If you're new to The Academy or know someone who is missing out on free learning, contact your Customer Experience Manager or the Support Team to sign up today!