Skip to main content

Relative Date Presets

When filtering by a Date or DateTime attribute, Protrak offers a set of relative date presets in addition to fixed dates and comparisons (Equals, Greater Than, Between, etc.). A relative preset does not point at a fixed date — it is re-evaluated every time the filter runs, against the current moment and the tenant's local timezone.

This page lists every preset and exactly what range of records it returns.

How to read the table​

  • Result describes the rule in plain language.
  • Tenant Local Time Range and UTC Time Range show the actual boundary instants the preset resolves to, computed live from your browser's current time (as a stand-in for "now"), so you can see a concrete example rather than an abstract formula.
  • A range shown as [Start, End) means Start is included and End is excluded — a record exactly at the End instant is not returned. A range shown as [Start, End] means both ends are included.
  • Click Reload current time to recompute the example against the current instant.

Notes​

  • The example above uses your browser's local timezone as a stand-in for the tenant's configured timezone, so you can see live, concrete boundaries. In the product, the boundary is always computed against the tenant's configured timezone, not the viewer's device timezone.
  • NextWeek intentionally spans 8 days rather than 7 — this is a deliberate platform behaviour, not an error.
  • Today is inclusive on both ends ([Start-of-day, End-of-day]). All six relative presets (LastOneWeek, LastOneMonth, LastOneYear, NextWeek, NextOneMonth, NextOneYear) are inclusive of their starting instant and exclusive of their ending instant.