Trying to parse Google Sheets unformatted date time serial number on Make.
Saw this post and tried multiplying the value by 86400 before parsing it.
But it’s giving a future date time.
I tried parsing 45479 like this {{parseDate(45479 * 86400; “X”)}}
The flow returned July 8, 2094 5:30 AM even though it’s supposed to mean 6 July 2024 00:00 IST.
P.S. Google Sheets seems to be converting serial number 1 to 31/12/1899 00:00:00
Welcome @Atishay_Jain.
Google Sheets date serial is the number of days since December 31, 1899.
For example, January 12, 2021 is stored as 44208.
One option is to format the date in Google Sheets and that’ll often carry through Google Sheet module calls.
The next is to is recognize the difference between Google Sheets time start and Unix’s timestamp of 25569 days.
So we need to decrease the given Google Sheets serial date by Unixtime start equivalent, and convert that result by seconds in days. Finally, we can get the Unixtime and nicely display it.
My example below sets a few times to check, and converts them from Google Serial to Unixtime.
blueprint.json (7.2 KB)
