Skip to content
 

MonthName Function

Uses

The MonthName function can be used to display the name of the month, when you provide a number between 1 and 12 (1 being January). It is useful for showing the month name in Group titles or labeling groups in charts.

It can be combined with the DatePart function to return the month name of a variable or calculation.

MonthName

Syntax Variable Description
MonthName(month, abbr) Month A number from 1 to 12.
abbr Optional. A Boolean value. If true, the month name is abbreviated. The default is false.

Examples

Example Result
MonthName(5) “May”
MonthName(10) “October”
MonthName(10,True) “Oct”
MonthName(DatePart(“m”, CurrentDate)) “October” when the current date is 10/5/10.

Other ways of showing the Month Name

You can also use the ToText field to display the name of the month.

Examples (where CurrentDate=10/5/10)

Example Result
ToText(CurrentDate,’MMM’) “Oct”
ToText(CurrentDate,’MMM’) “October”
ToText(CurrentDate,’MMMM yyyy’) “October 2010″
ToText(CurrentDate,’MMMM, yyyy’) “October, 2010″

Leave a Reply