Returns the name of the month of a specified date.

Syntax

CMONTH(<expD>)

<expD>

The date whose corresponding month name to return.

Description

CMONTH( ) returns a character string containing the name of the month in which a date falls. To return the month as a number from 1 to 12, use MONTH( ).

If you pass an blank or invalid date to CMONTH( ), it returns "Unknown".