MonthName Function

Returns a string indicating the specified month.

Syntax

MonthName ( month [, abbreviate ] )

The MonthName function syntax has these arguments:

Argument

Description

month

Required. The numeric designation of the month. For example, January is 1, February is 2, and so on.

abbreviate

Optional. Boolean value that indicates if the month name is to be abbreviated. If omitted, the default is False, which means that the month name is not abbreviated.

Query examples

Expression

Results

SELECT Monthname("10") AS Expr1 FROM ProductSales;

Returns the "Full" name of the month for the number representing the 'month'. Result: "October".

SELECT Monthname("10",True) AS MonthTest FROM ProductSales;

Returns the "abbreviated" name of the month for the number representing the 'month' and displays in the column "MonthTest".Result: "Oct" returns the "Full" name of 'month' of the values in the field "DateofSale" from the table "ProductSales" and displays in the column "MonthTest".

See Also

Choose the right date function

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×