Notion search object filter not working for dates OR dates formatted to string

[jenni_jang]

This is within Notion. I am trying to look up database item based on a date from another database.

This is the error I get:
[400] body failed validation. Fix one:
body.filter.or[0].formula.string should be defined, instead was undefined.
body.filter.or[0].formula.checkbox should be defined, instead was undefined.
body.filter.or[0].formula.number should be defined, instead was undefined.
body.filter.or[0].formula.date should be defined, instead was undefined.

I tried searching within one database for a date string “01/01/2024” and it still does not work.

I spent hours on this by now and can’t figure out why. Can you please help?

What I’m trying to do:
I have a page in database A that is automatically created everyday, with the date automatically populated.
I have another database B where I tag the dates. I want to be able to automatically search the dates tagged in database B in the date column in database A and automatically update the “relational” column in B with the related date page found in A.

Let me know if you need more info. Thanks

[Simo]

Did you also try to use the filter “Formula - date - equals” instead of “text: equals”?

If the “Due Date_formatted” Notion property is of date type, using the appropriate filter data type may help with the issue.

Let us know how it goes

[Martin_Korbel]

Hey, I have exactly the same problem.
I have tried your suggested approach but it doesn’t work.
I am looking for fields that do not have the date empty.

And this is the error I get.

[Simo]

Hi, I tried to reproduce this but it worked for me, using this filter on a Notion “search objects” module. Are you still experiencing the error?