Result = Year ( Date AS Date ) AS Integer

Returns the year component of a Date value.

Examples

PRINT Now; " -> "; Year(Now)
05/16/2002 22:31:30 -> 2002