This function returns the month corresponding to the specified date value.
Syntax
MONTH(date)
Arguments
Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4). For more details on the date inputs, refer to the discussion in Date and Time Functions.
Remarks
The month is returned as an integer, ranging from 1 (January) to 12 (December).
Data Types
Accepts numeric, string, or DateTime object data. Returns numeric data.
Examples
MONTH(L4)
MONTH(R4C12)
MONTH(366) gives the result 12
MONTH("12/17/2004") gives the result 12
Version Available
This function is available in product version 1.0 or later.
See Also
DAY | EOMONTH | YEAR | Date and Time Functions