Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

MonthName Function

Returns a string indicating the specified month.


                      MonthName(
                      month[, abbreviate])
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.

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". 

Community Additions

Show:
© 2014 Microsoft. All rights reserved.