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.

I have been working on this issue for days so any help I can get will be greatly appreciated.

We are logging some Pipedrive data in Excel.

Firstly I’m in Sydney Australia and am successfully converting the Pipedrive date from UTC to Sydney.

See image.

This conersion works BUT it shows up in Excel as the date in text format. It does not show up in DATE format although i have done the following:

  • Set the column format to date with “dd/mm/yyyy”
  • Set the calculation field to AUTO

 

If i go into the field and hit enter it will convert to Date format.

But As this will have 1000’s of lines and we are automatically generating reports / dashboards based on the date i can not have someone try to convert this manually each time.

 

Is there something i am doing wrong

 

Thanks in advance

Paul

 

Hi ​@paula_gfs, hope you're doing well!

It is curious that once the column format is set to date with “dd/mm/yyyy”, this issue would persist.

Do the cells of your date column in Excel have a formula, or are they completely blank? If you’re able to share a screenshot of the formatting of a blank cell, that would be great (please censor any personal/sensitive information)!

 

Looking forward to hearing from you 😊

Hi ​@paula_gfs 

Here’s an alternative…

Use Airtable instead of Excel.

Airtable has Date field types. (INFO)

For Date field types you can specify the date format.

Also, there are Formula field types, and you can use a formula to manipulate the date format.

There are other advantages of using Airtable instead of Excel in automations.

​@paula_gfs 

Feedback from ChatGPT…

 

Reply


Terms & Conditions