Month

Retrieve the month component from a specified date.

SELECT Month(#05/17/2017#);

Definition and Usage

The Month() function retrieves the month component from a given date, returning an integer between 1 and 12.

Month(date)

Parameter	Description
date	Required. A numeric or string expression that represents a valid date.

WORKS IN

From Access 2000

Retrieve the month component of today’s date.

SELECT Month(Date());

Retrieve the month component from the “BirthDay” column in the “Employees” table.

SELECT Month(BirthDate) FROM Employees;