Skip to main content
Best answer

Filter with the relative date

  • December 21, 2020
  • 3 replies
  • 4093 views

Hi all.

I want to integrate our marketing automation platform Autopilot with our CRM Pipedrive.

I have several scenarios. One of them is a bit problematic for me.

I want to trigger the automation (a set of letters) in Autopilot only if the user that has got to the Autopilot is not engaged with our sales team. But often the only change in the CRM is the activity they make. So, I need to filter out the users that were engaged by our sales team during the last 90 days. For this I have to set a relative date in the filter, not the exact one.

But I really don’t know how to deal with this. 

Below is the filter I try to make

Could you please help me with this issue?

 

Best answer by EnnesBest answer by Ennes

Hey @Tania_Beet 

this is a nice one. What you have to do is basically described here.

Before you create your step you have to add some more steps and create today's date:

In your case: you would use the Zap Meta Human Now - 90 days.

After that you can check if 90 days have gone by since the “last activity”:

Instead of the formula, you would “Last Activity” and compare it via the if formula with the output you created before (Today - 90 days). If “Last Activity” < Output (Today -90 days), then the Formula should result in True.

 

In the next step you should implement it in the filter:

I hope this helps you :)

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • December 21, 2020

You made need to add a Formatter (Date/Time Add/Subtract) step before to dynamically adjust the current date to go back 90 days then use that in the Filter step.

Use timestamp of when the Zap runs.

https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

Check out this article:

https://community.zapier.com/news-and-announcements-10/filter-and-paths-now-support-dynamic-values-6999

 


Ennes
Forum|alt.badge.img+5
  • Tinkerer
  • 130 replies
  • Answer
  • December 21, 2020

Hey @Tania_Beet 

this is a nice one. What you have to do is basically described here.

Before you create your step you have to add some more steps and create today's date:

In your case: you would use the Zap Meta Human Now - 90 days.

After that you can check if 90 days have gone by since the “last activity”:

Instead of the formula, you would “Last Activity” and compare it via the if formula with the output you created before (Today - 90 days). If “Last Activity” < Output (Today -90 days), then the Formula should result in True.

 

In the next step you should implement it in the filter:

I hope this helps you :)


  • Author
  • Beginner
  • 1 reply
  • December 22, 2020

Thanks a lot for your answers. Trying to implement your recommendations.