The date fields that are available in BI criteria are enabled to handle relative dates. Relative date fields are used to enter an amount of time relative to the current date/time (from 5 days ago through to today).
By default, the date fields in business intelligence criteria are date/time fields. This means that when you enter a relative date, it is relative to the current date and time. For example, if the current date/time is 2024-06-28 14:00:00 and you enter -2D to 0D, you are asking for results from 2024-06-26 14:00:00 to 2024-06-28 14:00:00.
If you prefer to ignore the current time when you specify a relative date, you can modify the criteria in the Registry. If you make this modification, entering -2D to 0D relative to the date 2024-06-28 would return results from 2024-06-26 midnight to 2024-06-28 inclusive.
To change the date/time criteria, refer to Modifying Date and Time Criteria.
Example Relative Date Ranges
•Yesterday: -1D =0h =0m =0s to =0h =0m =0s
•Today: =0h =0m =0s to +1D =0h =0m =0s
•Last Day of Current Month: =31D = 23h =59m =59s
•Any Time This Month: between =1D = 0h =0m =0s to +1M =1D = 0h =0m =0s
•Any Time Next month: between +1M =1D = 0h =0m =0s to +2M =1D = 0h =0m =0s
