Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Epoch & Unix Timestamp to GMT

Highlighted
8 - Asteroid

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels