Date expressions

A date expression evaluates to a DATE data type value.

MAIN
  DEFINE r, c DATE
  LET c = TODAY + 4
  LET r = ( c - 2 )
END MAIN

The operands of a date expression can be one of:

• A string literal that can be evaluated to a date according to DBDATE environment variable.
• A variable or constant of type DATE.
• A function returning a single Date value.
• A unary + or - associated to an integer expression representing a number of days.
• The TODAY constant.
• A CURRENT expression with YEAR TO DAY qualifiers.
• An EXTEND expression with YEAR TO DAY qualifiers.

If a date expression includes an operand whose value is not a date data type, the runtime system attempts to convert the value to a date value according to the data conversion rules.

If an element of an date expression is NULL, the expression is evaluated to NULL.