Category: Date and Time function
This function returns the corresponding month number, 1 through 12, from date.
Argument | Type | Description |
---|---|---|
date | Date or Number (date serial) | An expression representing a date. The date value to derive the month number from. |
Return value type: Number
The date argument can take any value or expression that evaluates to a date serial value. Examples include:
month(42097) //Returns 4 (42097 corresponds to April 4th, 2015.)
month(#2014-01-01) //Returns 1