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