Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Date Match
DATE_MATCH returns 1 if the input date is part of each non empty filter list. Each filter list represents a date type. The first list represents a set of years, which is filtered for. The second a list of quarters and so on. An empty list is not considered for filtering.
Syntax
DATE_MATCH(column, [YEARS], [QUARTERS], [MONTHS], [WEEKS], [DAYS])
Examples
[1] Match date with specifying all filter lists.
Query
Column1
DATE_MATCH( "Table1"."Column1", [2008], [1,2], [1,2,3,5], [1,6,11,21], [1,8,15,22] )
[2] Filter lists don't match any date
Query
Column1
DATE_MATCH( "Table1"."Column1", [2008], [1,2], [1,2,3,5], [1,6,11,21], [1,8,15,22] )
[3] Match date with empty filter lists for quarters and weeks.
Query
Column1
DATE_MATCH( "Table1"."Column1", [2008], [], [1,2,3,5], [], [1,8,15,22] )