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.

min

monthIndex

Last modified 1yr ago