Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
DateTime Difference Functions can be used to calculate the time difference between two DATEs.
- MILLIS_BETWEEN, SECONDS_BETWEEN, MINUTES_BETWEEN, HOURS_BETWEEN, DAYS_BETWEEN, MONTHS_BETWEEN and YEARS_BETWEEN calculate the difference between two DATEs in the corresponding time unit.
- DATEDIFF also calculates the difference between two DATEs; the time unit can be specified as an argument.
- WORKDAYS_BETWEEN calculates the number of workdays between two DATEs using a specified TFACS style calendar table.
- DATE_BETWEEN checks whether a DATE is between two other DATEs.
Content