My goal is for Zapier to find a Notion item based on a date field called “Expiration date”.
Within the Zap, I am given 2 options that are pertinent to the step:
- Expiration date filter (of which I can choose from the following options: before, after, equals, on_or_before, etc) - set to “equals”
- Expiration date (actual value of the field) - populated as today’s date.
Each item in my Notion database has a unique value in its “Expiration date” field, so ideally, this step will search for the item who’s date is today. I’ve already setup steps earlier within the zap to determine today’s date and format it as YYYY-MM-DD, and it outputs correctly.
The problem is that when the step tries to find the the item with a date matching today’s it returns no results even though there is most definitely an item that exists and matches.
Does anyone know why this isn’t working? When I set the date filter to “on_or_after”, it pulls up the item for tomorrow, but it doesn’t find the item for today, but it finding tomorrow’s confirms that my date is formatted correctly.
See screenshots below: