Hi,
when a deal is transferred from Hubspot to excel, the dates always break format and put random numbers in (the hashtags).
How do I setup a zap that makes sure the date format stays when its being transferred from HubSpot to Excel, and keeps the format when a deal update is done. Thanks
+14
Hi
In Excel, try setting formatting the column type. (Home > Number Format > Long Date)
Hi, The issue is the date comes through as a bunch of numbers. How do I fix this? Seen top left of image
+14
You can use this Zap action: Formatter > Date & Time > Format
could you please show the structure to set this up? I can’t seem to get it working. Thanks
+14
To help us have context, post screenshots with how your Formatter Zap step is configured.
+14
What are you still having trouble with in the Zap step config?
when I go to update a close date on hubspot, the number is still coming out as a unix number, not the date
+14
None of the Zap steps shown in previous screenshots are related to updating the Deal Close Date in HubSpot.
Can you post a specific example of the input and output values?
+14
When you test live, check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow between steps and troubleshoot: https://zapier.com/app/history/
It may be that the Excel is interpreting the data point as a number rather than as a date since the column has different date formats.
In Excel, try setting formatting the column type. (Home > Number Format > Long Date)
This is what happens, I’m guessing I’m having a similar issue with the other dates as well, Just not sure what is going wrong.
+14
As an alternative, I’d recommend using Airtable instead of Excel.
Airtable has a dedicated Date field type: https://support.airtable.com/docs/date-and-time-field
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
