AnsweredAssumed Answered

UNIX timestamp to FMP date

Question asked by vindauga on Sep 20, 2018
Latest reply on Sep 22, 2018 by fmpdude

Hi folks,

Another day, another question.


How can you calculate (convert) a UNIX timestamp "1537476113" to an FMP understandable timestamp without using any timezone conversion. The timestamp is from New York so I don't want to convert it to my local time here in Belgium.


I tried, without success:

GetAsTimestamp ( (GetAsNumber (myfieldname) )

    + GetAsNumber (Timestamp ("01/01/1970" ; "00:00:00"))

    + GetAsNumber ( Get(CurrentTimestamp) ) )

Your input is highly appreciated.