Skip to main content
Filters time fields for dates before a specified date. Returns rows where the date is less than the specified date.

​
Syntax

<time_field>:
  before: <date>

​
Properties

​
time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
​
before
string | date
required
The date threshold. Returns rows where the field value is less than this date. Can be:
  • Fixed date - Specified in YYYY-MM-DD format. For example, 2024-01-01.
  • Relative date - For example, today, 7 days ago

​
Examples

Date is before January 1, 2024
users.created_at:
  before: 2024-01-01
Date is before today's date
orders.order_date:
  before: today