Function: Year

Description

Returns the year portion of a date. Valid range is 1601-2400.

Syntax

Year(date)

Arguments

date can be a constant, a date field, an expression that results in a date or a function that returns a date.

Return value

This function returns a number in the range 1601-2400.

Calculated field example

If the Ship_date field contained the value 19920801, the following calculated field expression would return 1992: Year(Ship_date)

Filter/Find example

Records with a Ship_date field value of 19940303, 19940601 or 19940217 can be selected or found using the expression:  Year(Ship_date)=1994