Producing Customized Reports Using CA Earl › Date Processing › CTSEDATE Date Function Calls › SUB_YEARS Function—Subtract Years From a Date

SUB_YEARS Function—Subtract Years From a Date

Use the SUB_YEARS function to subtract a number of years from a date, giving a resultant date.

DEF FROM_DATE    (P 7.0) = NONE 'FROM' 'DATE'
DEF YEARS        (P 7.0) = NONE 'YEARS' 'SUBTRACTED'
DEF RESULT_DATE  (P 7.0) = NONE 'RESULT' 'DATE'
DEF FUNCTION      (X 80) = NONE
SET FROM_DATE = EXPDT
SET YEARS     = 3
SET FUNCTION  = 'SUB_YEARS'

CALL CTSEDATE USING FUNCTION
                    FROM_DATE
                    YEARS
                    RESULT_DATE