MS Access Month() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
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
