Skip to main content
Filters time fields for dates falling within a specified range. Returns rows where the date is between the start and end dates (inclusive).
This filter is inclusive of the start date and end date.

​
Syntax

<time_field>:
  between_dates: [<start_date>, <end_date>]

​
Properties

​
time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
​
between_dates
date[]
required
An array with two date values: [start_date, end_date]. Dates can be:
  • Fixed date - Specified in YYYY-MM-DD format. For example, 2024-01-01.
  • Relative date - For example, today, 7 days ago

​
Examples

Between two fixed dates
users.created_at:
  between_dates: [2024-01-01, 2024-12-31]
Between two relative dates
events.event_date:
  between_dates: [7 days ago, today]