Date variable or literal date
An Integer between 1 and 12
Returns an integer representing the month of the year of a given date expression
Nothing, Month returns
The validity of the date expression, as well as the position of the
month element within the date expression, is initially determined by
the locale settings of the current Windows system. However, some
intelligence has been built into the Month
function that surpasses the usual comparison of a date expression to
the current locale settings. For example, on a Windows machine set to
US date format (
mm/dd/yyyy), the date
“13/12/1998” would technically be
illegal. However, the Month function returns 12
when passed this date. The basic rule for the
Month function is that if the system-defined
month element is outside legal bounds (i.e., greater than 12), the
system-defined day element is assumed to be the month and is returned
by the function.
Since the IsDate function adheres to the same rules and assumptions as Month, it can be used to determine whether a date is valid before passing it to the Month function.
Visual Basic also has a new MonthName function for returning the name of the month.
You can also use the DatePart function.