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

DAY, HOUR, MINUTE, NOW, SECOND, TIME, YEAR