Producing Customized Reports Using CA Earl › Date Processing › CTSEDATE Date Function Calls › NUM_DAYS Function—Calculate Days Between Dates

NUM_DAYS Function—Calculate Days Between Dates

Use the NUM_DAYS function to calculate the number of days between two dates. The function subtracts TO_DATE from the FROM_DATE and places the difference into DAYS. All date fields are four-bytes packed.

DEF FROM_DATE     (P 7.0) = NONE 'FROM' 'DATE'
DEF TO_DATE       (P 7.0) = NONE 'TO' 'DATE'
DEF DAYS          (P 7.0) = NONE 'DAYS' 'BETWEEN'
DEF FUNCTION       (X 80) = NONE
SET FROM_DATE = CDATE
SET FUNCTION  = 'NUM_DAYS'

CALL CTSEDATE USING FUNCTION
                    FROM_DATE
                    TO_DATE
                    DAYS