Hello,

I have a column in one of my Airtables that contains the date of when a piece of information was published on my site.

I am trying to set an automation that looks at each row of my table every day and sends an email if any record i have becomes 60 days after the date I enter in the "Date" column. 

To test out the automation:

• I set the date for one of my rows of when it was published to 3/20/2024 (this is now 3 days since that date)

• i am setting the trigger to just be 1 day after the date.  The condition is "When ["date"] [is after] [number of days ago] [1], send me an email

For some reason, when i set this all up, it tells me that the table does not contain any records that match the provided filters.

I don't quite understand this because in my test above, it is now 3 days after 3/20/24 so based on the conditions i set up, it is at least 1 day after 3/20/24, so shouldn't it return my test record and then be able to send me out a test email?

Appreciate any clarifications about what I'm not doing or understanding correctly. 

thanks so much,
Matt