Year

Retrieve the year component from a specified date.

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

Definition and Usage

The Year() function retrieves the year component from a given date, returning an integer between 100 and 9999.

Year(date)

Parameter	Description
date	Required. A numeric or string expression representing a valid date.

WORKS IN

From Access 2000

Retrieve the year component of today’s date.

SELECT Year(Date());

Retrieve the year component from the “BirthDate” column in the “Employees” table.

SELECT Year(BirthDate) FROM Employees;