Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
This function rounds a DATE input down to the week by setting its HOUR, MINUTE, SECOND and MILLISECOND values to their ground state. The DAY value is set to the Monday of the week of that date.
Syntax
ROUND_WEEK ( table.date_column )
Example
Round dates down to the week:
Query
Column1
ROUND_WEEK ( "Table1"."Date" )