year

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.