Returns a whole number between 1 and 12, inclusive, representing the month of the year.
Month(date)
The date argument is any numeric or string expression, or any combination, that can represent a date. If date contains Null, Null is returned.
Date Function, Date Statement, Day Function, Now Function, Weekday Function, Year Function.
This example uses the Month function to obtain the month from a specified date. In the development environment, the date literal is displayed in short date format using the locale settings of your code.
MyDate = #February 12, 1969# ' Assign a date.= Month(MyDate) ' MyMonth contains 2.
The following example uses the Month function to set criteria in a query showing which orders were placed in December. Suppose you have an Orders table that includes an OrderID field and an OrderDate field. For example, you can create a new query on the Orders in the Query window, drag the OrderID field onto the query design grid from the Orders table, and enter the following expression in the Criteria cell under the OrderID field.
(Month([OrderDate]) = 12)