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