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.

This is doing my head in!

 

My Google spreadsheet date is 07/06/2006 (DD/MM/YYYY) i.e. 7 June 2006

I want to load this date into SalesForce via a zap.

 

Zaper was loading this date into SalesForce as 06/07/2006 (6 July 2006)

 

  1. If I use the Zapier Formatter with the following perameters

           From format: DD/MM/YYYY (i.e. 7 June 2006 - which is CORRECT)

           To format:  DD/MM/YYYY

           Then Zapier tells me the output format will be 06/07/2006 (6 July 2006 - ie. WRONG) and when I run the Zap it loads the (wrong) July date into SalesForce.

 

  1. If I use the Zapier Formatter with the following perameters (screenshot below)

           From format:  DD/MM/YYYY

           To format:      MM/DD/YYYY (i.e. 6 July 2006 which is wrong)

 

Then Zapier tells me that the output format (screenshot 2 below) will be 07/06/2006 (7 June 2006 i.e. CORRECT) - 

 

but then what loads into SalesForce when I run the Zap is 06/07/2006 (6 July 2006 - which is wrong)

 

Grateful for a fix if anyone can help, thank you.

 

 

Hi ​@CatsCollege 

Try using this date format: YYYY-MM-DD

Best to use ISO date formats. (info)

 

Thanks for this. ​@Troy Tessalone, but still not working.😩

 

​@CatsCollege 

NOTE: You can avoid all this by using this GSheet date column format: YYYY-MM-DD

 

The Input Format and From Format differ.

Input Format: D/M/YYYY

From Format: DD/MM/YYYY

 

Also, we would need to see screenshots showing:

  • DATA OUT from the Formatter step
  • how the Salesforce Zap step is configured in EDIT mode for the field that has the variable mapped from the Formatter step

 

 

​@Troy Tessalone - Thank you!  the formatting of the GSheet and matching data In/Out of the Zapier formatter has now got it working and finally, I have 7th June in SalesForce.  THANK YOU so much!

YAY!!! That’s awesome news, ​@CatsCollege! 🎉 So pleased to see Troy was able to help point you in the right direction here—fantastic work as ever, ​@Troy Tessalone! 🙌✨

As an addendum to this post and anyone else who may have a similar problem….  I ended up with more date formatting issues on some other GS’s and the above suddenly did not work. Then I discovered that my laptop  system locale  was set to US date/time https://www.ninjaone.com/blog/changing-system-locale-in-windows/

 

and the settings on the GS’s  were also set to US date time. https://support.google.com/appsheet/answer/10106525#google-sheets

Once I changed these to my locale then Troy’s solution worked again.

That’s good to know, ​@CatsCollege! Thanks so much for circling back to share this with the Community. 🤗 I’m sure it’ll be super helpful for others running into a similar issue. Thanks again! 🧡

Terms & Conditions