MS Access Month() Function

The name of the pictureThe name of the pictureThe name of the pictureClash 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


-