asked on September 30, 2020
Hello,
We have been searching for a way to match ONLY blank date fields. We have a report that has a date column with some values and some blanks. We have not found any combination of "filter: { query : { } }" options that produces a result that excludes dates and includes blanks.
Any help is greatly appreciated. Thank you!
⋅ October 7, 2020
Hello, Charles,
Thank you for contacting us.
We want to explain that all invalid and blank dates are grouped under the "Invalid Date" member.
Therefore, the following filter can be used to filter out all members but blank and invalid dates:
"filter": {
"members": [
"delivered date time.[invalid date]"
]
}
Please see an example we have prepared to illustrate the described approach.
Our team hopes it works for you.
Kind regards,
Illia