This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have the following Epoch/unix timestamps
1480946172314
1482317587061
1481192391911
1481801842930
I would need to convert these date to GMT but all the options I look at are not workig
Generally Unix time is seconds passed since 1970-01-01, but these values appear to be in millisecond increments. So I converted this to seconds (divide by 1000) for the DateTimeAdd function of Alteryx as milliseconds are not supported.
DateTimeAdd("1970-01-01",[Unix]/1000,"seconds")
Hello @AndrewCrayford,
I tried using the following formula:
DateTimeAdd("1970-01-01 00:00:00",[Field1],'seconds')
For this epoch/unix time "1581431318" and its working for me:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards