YEAR function

Evaluates a date expression and returns the year value of that date, including the century, as an INTEGER value.

Syntax 

 

YEAR ( date )

 

YEAR ( datetime-expression )

date

A date expression for which you want to determine the year.

datetime-expression

An expression that evaluates to a DATETIME or DATETIME-TZ. The YEAR function returns the year of the date part of the DATETIME or DATETIME-TZ value.

Example 

This procedure uses the YEAR function to determine if an Order date is in this century or the next, and then uses a different display format for each:

 

r-year.p

DEFINE VARIABLE outfmt  AS CHARACTER NO-UNDO. DEFINE VARIABLE orddate AS CHARACTER NO-UNDO   LABEL "Order Date" FORMAT "x(10)".   FOR EACH Order NO-LOCK:   ASSIGN     outfmt  = IF YEAR(Order.OrderDate) >= 2000 THEN                 "99/99/9999" ELSE "99/99/99"     orddate = STRING(Order.OrderDate, outfmt).   DISPLAY Order.OrderNum orddate Order.Terms. END.

See also 

ADD-INTERVAL function, DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, INTERVAL function, ISO-DATE function, MONTH function, MTIME function, NOW function, TIME function, TIME-SOURCE attribute, TIMEZONE function, TODAY function, YEAR-OFFSET attribute