THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access MonthName() Function

❮ MS Access Functions

Example

Return the month name based on a given number:

SELECT MonthName(3);

Definition and Usage

The MonthName() function returns the month name given a number from 1 to 12.

Syntax

MonthName(number, abbreviate)

Parameter Values

Parameter Description
number Required. A number (from 1 to 12) that represent the month
abbreviate Optional. True means that the month name is abbreviated. False means that the month name is not abbreviated. False is default

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the abbreviated month name based on a given number:

SELECT WeekdayName(3, true);

❮ MS Access Functions