Filter for empty date values

System Information
  • Strapi Version: 3.6.1
  • Operating System:
  • Database: mySql
  • Node Version:
  • NPM Version:
  • Yarn Version:


I was wondering if there is a way to use the build in filters to look for empty date values. For example:

In this scenario I’d love to be able to search for where the “profile_completed_at” is “empty”.

I can order by empty, which kind of helps but with more data it will make it harder to see exactly where the cut off is.

Is this possible?


Depending on what data type profile_completed_at is you could always say is null or is "" which should be an empty string etc ? Not sure if that would work?

Thank you for your reply and suggestion. Unfortunately it’s not possible enter “” or “null” for this field (from the UI as it’s a datetime field. And even adjusting the URL manually causes the filter to render “is Invalid Date”.

After digging a bit more it looks like, from the stack trace, that the filter tries to convert the value to a datetime and cannot handle an empty date.

Unless I am missing something?