YEAR

Returns the year for a given date. 

Syntax

YEAR(date)

Arguments

date	Date value to extract year value. Use the format (year, month, day)

Example

YEAR( DATE(2002,10,12)) returns 2002.