Question

Find Table Records by Date Range does not return results despite having records matching the date range

  • 12 March 2024
  • 2 replies
  • 13 views

Table having records matching the date range in the Find Records action

 

I am trying the Find Records based on email and date from the table above.

The image below illustrates how I have set up the filter action.

Three lookup values have been defined:

  • email is exactly the email from the previous step
  • created_on is on or after current time minus 7 days 
  • created_on is on or before current time

No data is returned when testing the zap :( 

 

Thank you in advance for your help.

 

 

 

 


2 replies

SOLVED: The problem was with the lookup value for email. I was using the email from the incorrect action. I should have used the one from the loop.

Userlevel 7
Badge +14

Hi @cfarrugia 

For others, follow this help article: https://help.zapier.com/hc/en-us/articles/19695584120461-Filter-records-on-Zapier-Tables#h_01HAVQ0QEVB9KXHX4DFV79K92R

Reply