Returns the month of the year (1 to 12) from the specified date. For example, the function returns:
- 1 for 1 January 2012
- 12 for 31 December 2012
Syntax
month(date)
Parameters
date
can be any of the following:
- Another function that returns a date.
- A formula column that returns a date.
Examples
- If today is 1 January 2012, the following function returns 1:
month(today())
- The following function returns 1:
month(date(2013,01,01))