Returns the number of the month for a given Date or DateTime expression.
Syntax
MONTH(dExpression | tExpression)
Returns
Numeric
Arguments
dExpression
Specifies the Date expression for which you want MONTH( ) to return the month number.
tExpression
Specifies the DateTime expression for which you want MONTH( ) to return the month number.
Remarks
MONTH( ) returns a number from 1 through 12. January is month 1, and December is month 12.