MONTH returns the month number (1-12) of a date literal.

SYNTAX:

MONTH(date literal)

EXAMPLES:

MONTH(D) - Returns the month number for the current date (date being calculated). 

MONTH(#+1/1) - Returns the month number for the next month.