Skip to main content
Filters time fields by the month of the year. Returns rows where the date falls in the specified month.

​
Syntax

<time_field>:
  month_of_year: "<month_name_or_number>"

​
Properties

​
time_field
string
required
The time/date field to filter on, specified in the format view_name.field_name.
​
month_of_year
string
required
The month to filter for. The value can be either the full name of the month or a number:
  • 1 - January
  • 2 - February
  • 3 - March
  • 4 - April
  • 5 - May
  • 6 - June
  • 7 - July
  • 8 - August
  • 9 - September
  • 10 - October
  • 11 - November
  • 12 - December

​
Examples

Date is in January
users.created_at:
  month_of_year: "January"
Date is not in June
users.created_at:
  not_month_of_year: "6"