|
MONTHNAME |
Scroll |
The MONTHNAME function returns the name of month from a number from 1 to 12.
Category
Date / Time
Syntax
MONTHNAME(number)
Parameter Descriptions
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.
