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…

 

Thank you all for your responses.

Sbastian:  I’ve attached a couple screen shots. 

As you can see the date posted from Zapier is showing as text. When I press F2 and then press enter on the date it reverts to the correct format Excel is expecting it to be (as shown in the previous records).

 

The next scren shot is hte format I’m using in Excel for this field (column)

Thanks Troy - but really need to use Excel for various reasons

 

I will try that and let you know how I go

 

thanks

 

 

No luck with the 

 

DATEVALUE only works when the field only has a date but if it has a time in it as well - such as this: 

November 15 2024 09:58:18

 

it ends with ERROR

 

#VALUE!

 

Just really want to put a date in Excel from Zapier that comes in as a date not as a text field - so frustrating.

 

Any help woulf be really appreciated

 

Thanks

 

 

 

Hi ​@paula_gfs,

I recommend contacting our Support Team about this issue so they can examine the Zap and its logs more closely, as they have the appropriate tools for that. You can reach our Support Team here:  https://zapier.com/app/get-help

Hopefully, this helps.

Reply


Terms & Conditions