Epoch & Unix Timestamp to GMT

[AndrewCrayford]

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

[CharlieS]

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")

[afv2688]

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