Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
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
WORKDAYS_BETWEEN ( 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 assumes that only the weekends are days off.
Example
Here ADD_WORKDAYS is used without an existing working calendar. The function therefore adds weekdays except the weekends.
Query
Column1
ADD_WORKDAYS ( "Table1"."Calendar_ID", "Table1"."Column1", 1 )
Output
Result
Column1 : DATE |
---|
Sun Apr 16 2017 00:00:00.000 |
Mon Apr 17 2017 00:00:00.000 |
Tue Apr 18 2017 00:00:00.000 |