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

Эта функция добавляет рабочие дни к определенной дате на основе таблицы календаря в стиле TFACS.

Таблица календаря должна иметь ту же структуру, что и для 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.

• calendar_id: определяет, какой календарь из таблицы календаря используется.
  
• дата: базовая дата.
  
• number_of_days: количество рабочих дней, которые добавляются к базовой дате.
  

Если идентификатор календаря не существует в таблице календаря, ADD_WORKDAYS предполагает, что только выходные являются выходными.

Example

Here ADD_WORKDAYS is used without an existing working calendar. The function therefore adds weekdays except the weekends.

Здесь ADD_WORKDAYS используется без существующего рабочего календаря. Поэтому функция добавляет рабочие дни, кроме выходных.

Query

Column1

ADD_WORKDAYS ( "Table1"."Calendar_ID", "Table1"."Column1", 1 )

Input

Table1

Column1 : DATE	Calendar_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

Содержание

1. Data Types
2. DATE
3. FLOAT
4. INT
5. STRING
6. Functions
7. Aggregation Functions
8. GLOBAL
9. Pull Up Aggregation Functions
10. PU_AVG
11. PU_COUNT
12. PU_COUNT_DISTINCT
13. PU_FIRST
14. PU_LAST
15. PU_MAX
16. PU_MEDIAN
17. PU_MIN
18. PU_QUANTILE
19. PU_SUM
20. Standard Aggregation Functions
21. AVG
22. COUNT
23. COUNT_TABLE
24. COUNT DISTINCT
25. MAX
26. MEDIAN
27. MIN
28. QUANTILE
29. STDEV
30. SUM
31. TRIMMED_MEAN
32. VAR
33. Moving Aggregation Functions
34. MOVING_AVG
35. MOVING_COUNT
36. MOVING_COUNT_DISTINCT
37. MOVING_MAX
38. MOVING_MEDIAN
39. MOVING_MIN
40. MOVING_STDEV
41. MOVING_SUM
42. MOVING_TRIMMED_MEAN
43. RUNNING_TOTAL
44. HOUR_NOW
45. TODAY
46. DATE_BETWEEN
47. DAYS_BETWEEN
48. HOURS_BETWEEN
49. MILLIS_BETWEEN
50. MINUTES_BETWEEN
51. MONTHS_BETWEEN
52. SECONDS_BETWEEN
53. WORKDAYS_BETWEEN
54. YEARS_BETWEEN
55. ADD_DAYS
56. ADD_HOURS
57. ADD_MILLIS
58. ADD_MINUTES
59. ADD_MONTHS
60. ADD_SECONDS
61. ADD_WORKDAYS
62. ADD_YEARS
63. CALENDAR_WEEK
64. DATE_MATCH
65. DAY
66. DAY_OF_WEEK
67. HOURS
68. MILLIS
69. MINUTES
70. MONTH
71. QUARTER
72. REMAP_TIMESTAMP
73. SECONDS
74. TO_TIMESTAMP
75. YEAR
76. DateTime Rounding Functions
77. ROUND_DAY
78. ROUND_HOUR
79. ROUND_MINUTE
80. ROUND_MONTH
81. ROUND_QUARTER
82. ROUND_SECOND
83. ROUND_WEEK
84. ROUND_YEAR
85. DECISION_TREE
86. KMEANS
87. LINEAR_REGRESSION
88. Math Functions
89. ABC
90. ABS
91. CEIL
92. FLOOR
93. LOG
94. POWER
95. ROUND
96. SQRT
97. SQUARE
98. ISNULL
99. Process Functions
100. ACTIVATION_COUNT
101. CALC_CROP
102. CALC_CROP_TO_NULL
103. CALC_REWORK
104. CALC_THROUGHPUT
105. MATCH_PROCESS
106. PROCESS_ORDER
107. PROCESS EQUALS
108. SOURCE / TARGET
109. VARIANT
110. Statistic Functions
111. QNORM
112. ZSCORE
113. CONCAT
114. LEFT
115. LEN
116. LOWER
117. LTRIM
118. REVERSE
119. RIGHT
120. RTRIM
121. STR_TO_INT
122. SUBSTRING
123. UPPER
124. Operators
125. CASE WHEN
126. FILTER
127. Math Operators
128. Addition Operator
129. Division Operator
130. MODULO
131. Multiplication Operator
132. Subtraction Operator
133. Predicate Operators
134. IN
135. LIKE
136. Ссылки на мануалы