Loading lesson path
Concept visual
Start at both ends
Return the month part for a specified date:
SELECT Month(#05/17/2017#);The Month() function returns the month part for a given date. This function returns an integer between 1 and 12.
date )
Required. A numeric or string expression that can represent a valid date
Return the month part of today's date:
SELECT Month(Date());Return the month part of the "BirthDay" column in "Employees":
SELECT Month(BirthDate) FROM Employees;❮ MS Access Functions