MONTH( ) Function

Example   See Also

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.