Name
Month Function
Syntax
Month(date
)
-
date
Use: Required
Data Subtype: Any variant capable of being expressed as a date
Any valid date expression.
Return Value
A variant integer between 1 and 12.
Description
Returns a variant representing the month of the year of a given date expression.
Rules at a Glance
If date
contains Null
,
Month
returns Null
.
Programming Tips & Gotchas
The validity of the date expression and the position of the month element within the date expression are 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 U.S. date format (mm/dd/yyyy
), the date “13/12/2000” is technically illegal. However, theMonth
function returns 12 when passed this date. The basic rule for theMonth
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 asMonth
, it determines whether a date is valid before passing it to theMonth
function.
See Also
Day Function, IsDate Function, MonthName Function, Year Function |
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.