Month Function

Syntax:

Month(dateexpr)

Group:

Time/Date

Description: 

Returns the month of the year (1 to 12)

Parameters:

Parameter

Description

dateexpr

Return the month of the year for this date value. If this value is Null then Null is returned.

Example:

Sub Main
  Debug.Print Month(#1/1/1900#) ' 1
  Debug.Print Month(#2/1/1900#) ' 2
End Sub

See Also:

Date( ), Day( ), MonthName( ), Weekday( ), Year( )