I have read and tried every community/support article I can find, and I feel I’m missing some very very basic thing.
I have an Airtable with a field called Date, as you can see here:
I am attempting to use Zapier to find yesterday’s record, and look up the info to then automatically send an email, and I am stuck at the first part.
I use Date/Time to get yesterday’s date and format it:
And then I search:
And I get an error - every time.
In fact, if I change the “search value” to actually be the date written out, that fails too. I’ve tried using different date formats, but none work.
Please, I’ve spent way too much time already - I assume there’s a simple solution??
Thanks!
