The MONTHNAME function returns the name of month from a number from 1 to 12.
Category
Date / Time
Syntax
MONTHNAME(number)
Parameter and Description
| Parameter | Description |
|---|---|
| number | This parameter specifies a number from 1 to 12 that identifies particular month of the year. 1 = January 2 = February 3 = March 4 = April 5 = May 6 = June 7 = July 8 = August 9 = September 10 = October 11 = November 12 = December. |
Example
Determine the name of the month from the number 03 and map the result to target field MONTH_NAME.
MONTH_NAME = MONTHNAME (03)
Returns the value of 'MARCH' and maps the result to the target field.