day_of_month

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

Syntax

<time_field>:
  day_of_month: <day_number>

time_field

string

required

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

day_of_month

number

required

The day of the month to filter for. Value must be a number between 1 and 31.

First day of month

users.created_at:
  day_of_month: "1"

Not the first day of month

users.created_at:
  not_day_of_month: "1"