DATE_MATCH
Description
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])
NULL handling
If the input value is NULL, then the result is NULL as well.
Examples
[1] Match date with specifying all filter lists. | ||||||||||||||
| ||||||||||||||
|
[2] Filter lists don't match any date | ||||||||||||||
| ||||||||||||||
|
[3] Match date with empty filter lists for quarters and weeks. | ||||||||||||||
| ||||||||||||||
|
[4] Non-empty filter lists don't match any date. | ||||||||||||||
| ||||||||||||||
|