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