Skip to main content
Filters time fields for dates on or after a specified date. Returns rows where the date is greater than or equal to the specified date.

​
Syntax

<time_field>:
  on_or_after: <date>

​
Properties

​
time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
​
on_or_after
string | date
required
The date threshold. Returns rows where the field value is greater than or equal to this date. Can be:
  • Fixed date - A fixed date in YYYY-MM-DD format. For example, 2024-01-01
  • Relative date - A date relative to the current date. For example, 30 days ago, today

​
Examples

Date is on or after January 1, 2024
users.created_at:
  on_or_after: 2024-01-01
Date is 30 days ago or less
orders.order_date:
  on_or_after: 30 days ago