DateTime difference
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.