MS Access Year() 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 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