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.

Hey Community,

I'm facing a strange issue that I just can't figure out, and I was hoping you could help me out.

Here’s how my Zap is set up:

  • Data from a person is submitted via Typeform.
  • That data is then sent through Zapier to Pipedrive.

Everything works fine, except for one issue: for some reason, the date of birth is sometimes recorded incorrectly in Pipedrive. Even stranger, in some cases, the Zapier log still shows the correct date, but once it reaches Pipedrive, it appears with a one-day difference.

The issue is inconsistent—it doesn’t happen every time, but only in certain cases.

I've attached some screenshots for reference. Any ideas on what could be causing this?

Thanks in advance!

Hi ​@Emmanuellouf ,

Thanks for getting in touch. Dana here from Support - I'm happy to help today!

 

If the issue happens inconsistently, it could have to do with the format of the birthday logged-in Typeform. Because there are a few different ways of displaying a date, it would be helpful to specify the output format you want by adding a Formatter step. By doing that, the result in the Pipedrive will be consistent, without the system getting confused. 

If the date format in Typeform is dd/mm/yyyy (as seen in one of the screenshots), use that as the input date format. More information is found here:

https://help.zapier.com/hc/en-us/articles/8496257974029-Modify-date-and-time-formats-in-Zaps

 

That said, the result being one day off is odd. The first thing that comes to my mind is that there is a timezone different at play here.

Does your Typeform or Pipedrive step pull timezone data anywhere in the steps? Please review your Zap’s configuration in case any of the fields require a timezone.

After that, you can ensure both apps are using the same timezone so that there is no discrepancy.

 

I hope it helps!

If there is anything else I can help you with, feel free to let me know!

Thanks,

Hi Dana, thanks! I’ll give this a try.

​@Emmanuellouf - the formatter is a great option!

Another thing to check is to make sure your systems are set to the same Time Zone. (I ran into this a lot when my Zapier account was set to Pacific US time and the system I was writing to was based in Europe. (You can check your Zapier designated time zone by looking at your profile/account settings.)

 

Running the input and output date through formatter is a great idea no matter what. It ensures that the date format outputted is consistent regardless of how it gets entered, and you can set the Time Zone manually in there as well. (And it’s “free” - Zapier doesn’t use a task for Formatter steps.) Here’s a bit of focused documentation for Formatter. Good luck and let us know how it goes!

Thanks! I’ve checked the Time Zone, but here’s the setting like it should be. So I hope the formatter will do it’s magic. :)

Terms & Conditions