YEAR( )
Returns the four‑digit year value for a specified date value.
Syntax
YEAR(date)
date
The date or date expression from which you want to extract the year part.
Returns
The number that represents the four‑digit year for the specified date value.
Example
The following example gets the four‑digit year for each date value in the ShipDate data field, and adds 15 to the four‑digit year. For example, if the ShipDate value is Sep 16, 2008, YEAR( ) returns 2023.
(YEAR([ShipDate]) + 15)