Get Free Trial

I would like to apply a filter to match ONLY blank dates

Charles Felish asked on September 30, 2020

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!

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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,

Please login or Register to Submit Answer