YEAR( ) Function

  • Article

Returns the year from the specified date or datetime expression.

YEAR(dExpression | tExpression)

Return Values

Numeric

Parameters

  • 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.

Example

CLEAR
? YEAR(DATE( ))

See Also

DATE( ) | DATETIME( ) | DOW( ) | SET CENTURY