MS Access Year() Function
Multi tool use
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MS Access Year() Function
❮ MS Access Functions
Example
Return the year part of a specified date:
SELECT Year(#05/17/2017#);Try it Yourself »
Definition and Usage
The Year() function returns the year part of a given date.
This function returns an integer between 100 and 9999.
Syntax
Year(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 year part of today's date:
SELECT Year(Date());Try it Yourself »
Example
Return the year part of the "BirthDate" column in "Employees":
SELECT Year(BirthDate) FROM Employees;Try it Yourself »
❮ MS Access Functions
