month
To return the month from a date value as a number
Use this function to return the month from a date value. This will be a number between 1 and 12, with January = 1, February = 2, … December = 12.
Syntax
month(date)
month(appointment)
month(timestamp)
Return
number
Examples
month(myDate) To return the month of a given date as a number.
month(today()) Result: 5 (on May 31, 2021)
month(today()) + 3 Result: 8 (on May 31, 2021)
month(myAppointment) To return the month of the start date of a given appointment as a number.
month(datetime) To return the month of a given timestamp as a number.
See also
date, which converts to or returns a date value.
day, which returns the day of the month from a given date value as a number.
quarter, which returns the quarter of a given date value as a number.
week, which returns the calendar week of a given date value.
year, which returns the year of a given date value.