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 )
Input
Table1
Column1 : DATECalendar_ID : STRING
Sat Apr 15 2017 00:00:00.000
'Does not exist Calendar ID'
Sun Apr 16 2017 00:00:00.000
'Does not exist Calendar ID'
Mon Apr 17 2017 00:00:00.000
'Does not exist Calendar ID'
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
  • No labels