THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Month() Function

❮ MS Access Functions

Example

Return the month part for a specified date:

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

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

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 month part of today's date:

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

Example

Return the month part of the "BirthDay" column in "Employees":

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

❮ MS Access Functions