Skip to main content
Filters time fields by the day of the week. Returns rows where the date falls on the specified day of the week.

Syntax

<time_field>:
  day_of_week: "<day>"

Properties

time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
day_of_week
string
required
The day of the week to filter for. The value can be either the full name of the day or a number:
  • 0 - Sunday
  • 1 - Monday
  • 2 - Tuesday
  • 3 - Wednesday
  • 4 - Thursday
  • 5 - Friday
  • 6 - Saturday

Examples

Day of week is Monday
users.created_at:
  day_of_week: "Monday"
Day of week is not Sunday
users.created_at:
  not_day_of_week: "0"