YEAR

Returns the year specified by a given date

Usage examples 

  • YEAR("1/5/2010")

  • YEAR(tableA.fieldB)

Syntax 

YEAR ( date )

  • date - a string or number representing a date

Returns 

number - the year of the date.

Functions reference