Month

Returns a whole number between 1 and 12, inclusive, representing the month of the year.

Structure

Month(date)

Parameters

The date argument is any expression that can represent a date. If date contains Null, Null is returned.

Example

The following example uses the Month function to return the current month:

Dim MyVar

MyVar = Month(Now) ' MyVar contains the number corresponding to the current month. |