MS Access Day() Function
Definition and Usage
The Day() function returns the day of the month for a given date.
This function returns an integer between 1 and 31.
Syntax
Day(date)
Parameter Values
Parameter | Description |
---|---|
date | Required. A numeric or string expression that can represent a valid date |
Technical Details
Works in: | From Access 2000 |
---|
More Examples
Example
Return the day of the month for the "BirthDay" column in "Employees":
SELECT Day(BirthDate) FROM Employees;
Try it Yourself »