Unix2UTC and UTC2Unix 02-09-2019 21:26 PM - last edited 02-15-2019 07:11 AM

[Greg_Deckler]

Here are a couple of quick calculations to convert Unix time to UTC time and vice versa.

Unix2UTC

Unix2UTC = 
VAR UnixDays = MAX([UnixTime])/(60*60*24)
RETURN (DATEVALUE("1/1/1970")+UnixDays)

UTC2Unix

UTC2Unix = 
VAR __utc = [Unix2UTC]
RETURN (__utc - DATEVALUE("1/1/1970"))*60*60*24

eyJrIjoiZjBkZmE5OGItMDg4MS00OGM1LWJkZmUtMGVhNjRmODU3M2M0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

[schnarf78]

Thank you @Greg_Deckler . The first calculation worked for me, although I had to remove the MAX formula, and first had to extract the numbers from the /Date(, but otherwise perfect!