MonthName

The MonthName function returns the name of the month component from a specified datetime value.

Syntax

MonthName(date)

Function arguments:

Notes

• If the date argument references text or number data, use the Date function to convert the value or column to the date data type.

Examples

Example 1

MonthName(Date("2023-05-04"))

Evaluates 2023-05-04 as a datetime value and returns May as the name of the month component.

Example 2

MonthName([Order Date])

References the Order Date column and returns the name of the corresponding month component for each row.