day_of_year

Filters time fields by the day of the year. Returns rows where the date falls on the specified day of the year.

Syntax

<time_field>:
  day_of_year: <day_number>

time_field

string

required

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

day_of_year

number

required

The day of the year to filter for. Must be a number between 1 and 365, or 366 for leap years.

Date is January 1

users.created_at:
  day_of_year: 1

⌘I