Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
This function rounds a DATE input down to the month by setting its DAY, HOUR, MINUTE, SECOND and MILLISECOND values to their ground state.
Syntax
ROUND_MONTH ( table.date_column )
Example
[1] Round dates down to the month:
Query
Column1
ROUND_MONTH ( "Table1"."Date" )