Type
Date Function

Purpose
The year function extracts the year from a date value.

Syntax
year( DATE VALUE)

Returns
An integer value from 0 to 99 (inclusive). The date format selected in Windows Control Panel changes the date sequence but does not affect which value is returned by a Date function.
If the year function is used on an extended date field or variable, it will return a four digit numeric string from 1776 to 9999.

Examples
year( 12/31/99)
Returns: 99 ( most North American formats)

year( 31/12/99)
Returns: 99 ( most European formats)

year(99/12/31)
Returns: 99 (_____parentheses_ Metric format)_____parentheses_

year( DATEFIELD)
Converts the year portion of the value in the DATE field into an integer from 0 to 99 for every record processed. If a record contains the value 12/31/99 in the DATE field, the function returns 99.