Hi, i am having issues converting the time in Unix time (60*60*24) to date time.
but i couldnt get it to work. i have the values like the attached in first picture. Please help me convert this number to datetime.
Solved! Go to Solution.
Adjust the formula with -6 as hours in the #duration part:
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, -6, 0, [UnixTime]/1000)
Thanks for the post, i got it to work for my data. Only one point was that the unit time I had was unix time in s not ms, so I didn't need the /1000. I think unix time is quite common in both formats.