I created workflow in which whenever a deal property is updated, new row is added to the Excel table but all of the dates Zapier is taking from Hubspot are in weird format which I can’t work out. I can’t use Date Formatter because it’s not regular date. All of the dates look like this 👇
Does anyone know how to fix it?
Whenever Property “Deal Stage” is updated a new row is added to the table in Excel
Best answer by ken.aBest answer by ken.a
Hi there @koc,
Welcome to the Community! 🎉
The HubSpot integration returns the date as a UNIX format. There are two workarounds for this:
The other option would be to format the date within the spreadsheet itself, if you are comfortable using spreadsheet formulas. You could try this one: =((A1-21600000)/86400000)+25569 # .Then select the column and use Format -> Number -> Date time.
Amazing, thank you so much!! Unfortunately I have a free plan so couldn’t add more steps but spreadsheet formula works like a charm :) Thank you for your help!
The other option would be to format the date within the spreadsheet itself, if you are comfortable using spreadsheet formulas. You could try this one: =((A1-21600000)/86400000)+25569 # .Then select the column and use Format -> Number -> Date time.