between_dates - Filter operators

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>]

string

required

The time/date field to filter on, specified in the format view_name.field_name.

date[]

required

An array with two date values: [start_date, end_date]. Dates can be:

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]

⌘I