bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Day() Function

Example

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

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

ParameterDescription
dateRequired. A numeric or string expression that can represent a valid date

Technical Details

Works in:From Access 2000

Previous

MS Access DateValue() Function

Next

MS Access Format() Function