Year() Function in MS Access

Year() : Function in Microsoft Access is used to return the year part of a given date.

Syntax :

Year (date)

Parameter : This method accepts one parameter as mentioned above and described below :

• date : It is any variant, numeric expression, string expression, or any combination of these that can represent a date.

Returns : It Returns the year part of a specified date . If date contains Null, Null is returned.

Example-1 : Find Year from a specified Date :

SELECT Year(#05/17/2017#);

Output :

2017 

Example-2 : Find Year part of Today :

SELECT Year(Date());

Output :

2020

Example-3 : Find Year of Joining of the Employee :

SELECT Year(JoiningDate) FROM Employees;

Output :

1990
2004
1992

Note : There Should be JoiningDate column in Employees Database.Here, the Employees Database contains only 3 records.