Returns the year of a specified date.

Syntax

YEAR(<expD>)

<expD>

The date whose corresponding year number you want to return.

Property of

Date

Description

YEAR( ) returns a date’s 4-digit year number. The SET CENTURY setting has no effect on YEAR( ).

YEAR( ) returns zero for a blank date.