Month()

Month() - Determine the Month from a Date

Description

The Month() function is used to determine the month from a date variable or formatted string.

Integer = Month(date)

Returns number between 1 and 12 representing the month of the year.

Example

'Determine the day of April 19, 1964

MyDate = Month("April 19, 1964") 'returns 4

'Determine the month today

MyDate = Month(now)