Skip to content

Date Predicates

Date predicates evaluate fields that store calendar dates (ISO date values).
Many of these predicates update automatically as time passes.

Category: Basic comparisons

Is after

True if the stored date occurs after the configured date.

Example
  • Parameter: 2024-01-01
  • 2024-05-10 → ✔
  • 2023-12-31 → ✘

Is before

True if the stored date occurs before the configured date.

Example
  • Parameter: 2024-01-01
  • 2023-10-01 → ✔
  • 2024-01-01 → ✘
  • 2025-02-01 → ✘

Is equal to

True if the stored date is exactly the same as the configured date.

Example
  • Parameter: 2024-05-01
  • 2024-05-01 → ✔
  • 2024-05-02 → ✘

Category: Range

Is between

True if the date is within a configured date range (inclusive).

Example
  • Range: 2024-01-01 to 2024-12-31
  • 2024-06-10 → ✔
  • 2024-01-01 → ✔
  • 2023-12-31 → ✘
Note

Both the start and end dates are included.

Category: Relative time

Is in the past

True if the date occurs before today.

Example
  • Today: 2025-01-10
  • 2025-01-09 → ✔
  • 2025-01-10 → ✘
  • 2025-01-11 → ✘

Is in the future

True if the date occurs after today.

Example
  • Today: 2025-01-10
  • 2025-01-11 → ✔
  • 2025-01-10 → ✘

Is ago

True if the date is exactly N days before today.

Example
  • Parameter: 7 days
  • Today: 2025-01-10
  • 2025-01-03 → ✔
  • 2025-01-02 → ✘

Is less than ago

True if the date is within the last N days (strictly less than the specified interval).

Example
  • Parameter: 30 days
  • Today: 2025-01-10
  • 2025-01-05 → ✔
  • 2024-12-15 → ✔
  • 2024-11-01 → ✘

Is more than ago

True if the date is older than the specified number of days.

Example
  • Parameter: 30 days
  • Today: 2025-01-10
  • 2024-10-01 → ✔
  • 2025-01-05 → ✘

Is within next

True if the date falls within the next N days, relative to today.

Example
  • Parameter: 7 days
  • Today: 2025-01-10
  • 2025-01-11 → ✔
  • 2025-01-17 → ✔
  • 2025-01-18 → ✘
Note

The comparison window begins tomorrow, not today.

Is within previous

True if the date falls within the last N days.

Example
  • Parameter: 7 days
  • Today: 2025-01-10
  • 2025-01-09 → ✔
  • 2025-01-03 → ✔
  • 2025-01-02 → ✘

Category: Calendar

Is today

True if the stored date is the same as today’s date.

Example
  • Today: 2025-01-10
  • 2025-01-10 → ✔
  • 2025-01-09 → ✘

Is weekday

True if the date falls on Monday–Friday.

Example
  • "2025-01-06" (Monday) → ✔
  • "2025-01-11" (Saturday) → ✘

Is weekend

True if the date falls on Saturday or Sunday.

Example
  • "2025-01-11" (Saturday) → ✔
  • "2025-01-12" (Sunday) → ✔
  • "2025-01-13" (Monday) → ✘

Is start of month

True if the date is the first day of its month.

Example
  • "2025-03-01" → ✔
  • "2025-03-02" → ✘

Is end of month

True if the date is the last day of its month.

Example
  • "2025-02-28" (non-leap year) → ✔
  • "2024-02-29" (leap year) → ✔
  • "2025-02-27" → ✘

Is leap year

True if the date occurs in a leap year.

Example
  • "2024-05-10" → ✔
  • "2023-05-10" → ✘