THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Day() Function

❮ MS Access Functions

Example

Return the day of the month for a specified date:

SELECT Day(#05/17/2017#);
Try it Yourself »

Definition and Usage

The Day() function returns the day of the month (from 1 to 31) for a date.

Syntax

Day(date)

Parameter Values

Parameter Description
date Required. A valid date

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the day of the month for today's date:

SELECT Day(Date());
Try it Yourself »

Example

Return the day of the month for the "BirthDay" column in "Employees":

SELECT Day(BirthDate) FROM Employees;
Try it Yourself »

❮ MS Access Functions