Month

Return the month (a number from 1 to 12) for a given date.

Syntax
      Month(date_value)

Key
   date_value  A valid date.

The Month() function can be used in VBA or in an SQL query.

Examples

Dim intDemo as integer
intDemo = Month(dtmShiftEnd)
intDemo = Month(#30/12/2012 08:55:00 AM#)

Select * from orders where Month(Order_date) = 3;

“What would be the use of immortality to a person who cannot use well a half an hour” ~ Ralph Waldo Emerson

Related:

Day - Return the day of the month.
DatePart - Return part of a given date.
Year - Return the year for a given date.