Previous Topic: 'ADD_WORK'Next Topic: 'SUB_DAYS'


'NUM_DAYS'

The 'NUM_DAYS' function calculates the number of days between two dates. The function subtracts the "FROM_DATE" from the "TO_DATE" and places the difference into 'DAYS'. All date fields are 4-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