THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access MonthName() Function

❮ MS Access Functions

Example

Return the name of the month based on a number:

SELECT MonthName(3);

Definition and Usage

The MonthName() function returns the name of the month based on a number.

Syntax

MonthName(number, abbreviate)

Parameter Values

Parameter Description
number Required. A value from 1 to 12, that represent the month
abbreviate Optional. A Boolean value. True = the month name should be abbreviated. False = the month name should not be abbreviated. False is default

Technical Details

Works in: From Access 2000

More Examples

Example

Return the abbreviated name of the month based on a number:

SELECT WeekdayName(3, true);

❮ MS Access Functions