Date Range Presets
Date Range Presets provide predefined date ranges that can be used with the DateTime Filter block. Administrators can configure which presets are available and create custom presets.
Built-in Presets
The following presets are available by default:
| Preset | Description |
|---|---|
| Today | Current day (midnight to midnight) |
| Yesterday | Previous day |
| This Week | Current week (Monday to Sunday) |
| Last Week | Previous week |
| This Month | Current calendar month |
| Last Month | Previous calendar month |
| This Quarter | Current calendar quarter |
| Last Quarter | Previous calendar quarter |
| This Year | Current calendar year |
| Last Year | Previous calendar year |
| Last 12 Months | Rolling 12-month window |
| Last 24 Hours | Rolling 24-hour window |
| Last 7 Days | Rolling 7-day window |
| Last 30 Days | Rolling 30-day window |
| All Time | No date restriction |
Calculation Modes
Presets can use one of two calculation modes:
- MTM (Midnight to Midnight) - Ranges are calculated using UTC midnight boundaries. For example, "Today" starts at 00:00:00 UTC and ends at 23:59:59 UTC. This is the default mode for most presets.
- CT (Current Time) - Ranges are calculated relative to the user's current local time. For example, "Last 24 Hours" calculates from exactly 24 hours before the current moment.
Custom Presets
Administrators can create custom date range presets from the Admin Console > Settings section.
Each custom preset has:
- Direction -
last(past) ornext(future) - Amount - A numeric value (e.g., 3, 7, 90)
- Unit - The time unit:
hours,days,weeks,months,quarters, oryears
For example, a custom preset with direction last, amount 90, and unit days creates a "Last 90 Days" preset.