Skip to main content
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>

Properties

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.

Examples

Date is January 1
users.created_at:
  day_of_year: 1