On cell A5, I paste value - '1579478400000' and on cell A6, I set the following formula:
=(A5 / 86400000) + DATE(1970,1,1)
Next, I format the cell with custom format - 'mmm-dd-yyyy hh:mm:ss' and I'm seeing the converted datetime on cell A6 as follows: 'Jan-20-2020 00:00:00'.
I am using Zapier to pull a date field from a deal into Formstack and create a word document. My dates are appearing as Seb's above, but since I'm not in Excel or Google Sheets I can't use a formula. Is there a way to set the export format to date from Hubspot?
On cell A5, I paste value - '1579478400000' and on cell A6, I set the following formula:
=(A5 / 86400000) + DATE(1970,1,1)
Next, I format the cell with custom format - 'mmm-dd-yyyy hh:mm:ss' and I'm seeing the converted datetime on cell A6 as follows: 'Jan-20-2020 00:00:00'.