CMON() returns name of the month referenced by the specified DateTime.
Use CMON() to return the name of the month with the specified length.
CMON(D,N)
• | D specifies the datetime |
• | N specifies the field length. To display abbreviated month names, specify a shorter field length |
CMON() returns the name of the month for the supplied DateTime with a length N.
If the DateTime is invalid or blank, then CMON() returns blanks with a length N.
Valid dates are in the range January 2, 1900 to December 31, 9999.
Using a date of August 14, 2012:
CMON(‘20120814‘,3) = "Aug"
CMON(‘20120814‘,6) = "August"