ADD_WORKDAYS
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
This function adds working days to a given date based on a TFACS style calendar table.
The calendar table has to have the same layout as for WORKDAYS_BETWEEN.
ADD_WORKDAYS ( calendar_id, date, number_of_days )
calendar_id: defines which calendar out of the calendar table is used.
date: base date.
number_of_days: number of working days which are added to the base date.
If the calendar ID does not exist in the calendar table, ADD_WORKDAYS behaves like the ADD_DAYS function and adds the specified number of days to the date.
Example
[1] Here ADD_WORKDAYS is used without an existing work calendar. The function therefore adds the specified number of days.
|