Does anyone know how to convert a time in unix format to standar hour:minutes
Hi, check out the FORMAT_DATETIME_LOCAL formula → docs
Doesnt seem to be working for a unix timestamp.
If I use this formala on this timestamp: 1619769600 it comes back wrong (without the specific date, only the time changes and the date stays 1970).
What am I doing wrong?
Hi, the formula function takes the time in milliseconds so you’ll need to multiply your value by 1000 to get the right results.
Thanks! This is the solution.
var date = new Date(unix_timestamp * 1000);