MonthName

Returns a string indicating the specified month.

Structure

MonthName(month[, abbreviate])

Parameters

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.

Example

The following example uses the MonthName function to return an abbreviated month name for a date expression:

Dim MyVar

MyVar = MonthName(10, True) ' MyVar contains 'Oct'. |