MONTH

Returns the month of the year for a given date as a number

Usage

MONTH(date)

Parameters

date

(Required) The date from which to extract the month

Examples

Example With these variables Result

MONTH(event_date)

event_date is DATE(2024, 5, 28)

5

MONTH(DATE(2024, 1, 12))

(None)

1

Reminders

A text containing a date is not handled as a date. To have an actual date:

  • use the @DATE_QUESTION to set the variable
  • use a function that converts to a date: DATEVALUE(text_date)
  • use a function that returns a date: TODAY() or DATE(year, month, day)

See also