bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Month() Function

Example

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

Definition and Usage

The Month() function returns the month part for a given date.

This function returns an integer between 1 and 12.

Syntax

Month(
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 Minute() Function

Next

MS Access MonthName() Function