Loading lesson path
Concept visual
Start at both ends
Return the year part of a specified date:
SELECT Year(#05/17/2017#);The Year() function returns the year part of a given date. This function returns an integer between 100 and 9999.
date )
Required. A numeric or string expression that can represent a valid date
Return the year part of today's date:
SELECT Year(Date());Return the year part of the "BirthDate" column in "Employees":
SELECT Year(BirthDate) FROM Employees;❮ MS Access Functions