Search…
⌃K
Links

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.
Last modified 2mo ago