Month
MONTH(date)
Description
MONTH returns a whole number ranging from 1 to 12 that represents the month of the year, of a given date.The required parameter, date, can be any numeric or string expression, or any expression that represents a date.
Example
REM MONTH Example 'MONTH returns month of year of a date DIM When When = NOW PRINT "The MONTH of " & When & " is " _ & MONTH(When)
Output
The MONTH of 8/18/1998 10:52:44 PM is 8 (sample date output is system dependant)
Related Items