email automation question

Topic Labels: Automations
218 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


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,

2 Replies 2

Perhaps try using "Is number of days ago" instead?

Screenshot 2024-03-24 at 2.41.38 PM.png

5 - Automation Enthusiast
5 - Automation Enthusiast

That worked.  Thanks for the suggestion.