YEAR( ) Function

Example   See Also

Returns the year from the specified date or datetime expression.

Syntax

YEAR(dExpression | tExpression)

Returns

Numeric

Arguments

dExpression

Specifies a date expression from which YEAR( ) returns the year. dExpression can be a function that returns a date, or a Date-type memory variable, array element, or field. It can also be a literal date string, such as {^1998-06-06}.

tExpression

Specifies a datetime expression from which YEAR( ) returns the year.

Remarks

YEAR( ) always returns the year with the century. The CENTURY setting (ON or OFF) doesn't affect the returned value.