MonthName

Retrieve the name of the month corresponding to a numeric value.

SELECT MonthName(3);

Definition and Usage

The MonthName() function retrieves the name of the month corresponding to a specified numeric value.

MonthName(number, abbreviate)

Parameter

Description

number

Required. A numeric value ranging from 1 to 12, representing the month.

abbreviate

Optional. A Boolean parameter where:

WORKS IN

From Access 2000

Retrieve the abbreviated name of the month corresponding to a numeric value.

SELECT WeekdayName(3, true);