Month
Returns the month of the year (from 1 to 12) for the date entered as a parameter.
Syntax
Month(date)Mois(date)
date = date for which you want to retrieve the month of the year
Remarks
If you want to retrieve the current month, you can use the Now function as a parameter.
Example
Month(Now()) = current month; in January 2010, returns 1Day(Now()+1) = tomorrow's month, so on January 31, this will return 2 (for February)