Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi all,

Very happy with Zapier and enhancing our business. But struggling with this specific topic. 

When a customer buys a specific product, we trigger a mail sequence. But depending on the month they get a different mail sequence. So I want to filter the purchase date and based on that date add a ‘month tag’ in Convertkit. 

 

For example a customer buys a product on the 15th of January, I trigger Convertkit to set the tag 2022 January (tags are already created in Convertkit). And when a customer buys a product on the 3rd of February, I trigger Convertkit to set a tag 2022 February. 

 

I tried the filter option in Zapier and used ‘date after’ AND ‘date before’. For example, date after is 31st of dec and date before is ‘1ste of januari’. And I used the date format Zapier recommends. The purchase date is extracted from the purchase info. 

 

But the zap is stopped using sample data. 

 

Then I tried formatting the date and then set the ‘date after’. en ‘date before’ but stil not working. 

So I’m trying to figure out how to add the tag when the purchase occurs in a specific month. 

Hope you can help!

Kind regards, 

Lieke

Hey @Lieke from ELFIN ,

 

Can you post the screenshot of the Zap that you have built?

Yes, of course. 

The first part (until date/time formatting) is a filter on the SKU and adds a tag about the product. Then I format the purchase date. 

After formatting I added paths. So Path 2022 January sets a tag for January, Path 2022 for February and so on. 

 

 

 

Thanks in advance!

Hey @Lieke from ELFIN ,

The Path Condition will not match because the value is incorrect.

 

You can check the sample value below format which is YYYY-MM-DD HH:MM:SS

 

 

I want to add more as a suggestion to you - I don’t think you need paths and you should not use also, because you will have to update paths every month for which your Zap will be turned OFF. You can simply use Code By Zapier that will find month name and year from date of purchase value. 

 

Hope this helps!

 

Hi,

 

Thanks a lot I got the filter on the date working, so it really helped. 

 

Tried code by Zapier, but lack the skills to code this, so first I’m going to launch the product and see if it sells like I want to and then upgrade the zapp. 

 

Thanks a lot!

Hi @Lieke from ELFIN 

Using Paths for Tags likely won’t scale well.

Instead, try using a Formatter > Utilities > Lookup Table: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

This will make your Zap simpler and more dynamic.

Terms & Conditions