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.