Skip to main content
Question

Issue with Date Formatting in Zapier & Pipedrive


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!

Did this topic help you find an answer to your question?

4 replies

Dana.L
Forum|alt.badge.img
  • Zapier Staff
  • 5 replies
  • January 30, 2025

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.


Mistryer
Forum|alt.badge.img
  • New
  • 17 replies
  • January 31, 2025

@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. :)