Year() : Function in Microsoft Access is used to return the year part of a given 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 :
Example-2 : Find Year part of Today :
Example-3 : Find Year of Joining of the Employee :
SELECT Year(JoiningDate) FROM Employees;
1990 2004 1992
Note : There Should be JoiningDate column in Employees Database.Here, the Employees Database contains only 3 records.