Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

EPOCH Dates

markashman
8 - Asteroid

Anyone been able to convert an EPOCH date to date, format of yyyy-mm-dd?

 

Actually, nevermind, found a post on it I can try, would delete this post but cant see a way.

2 REPLIES 2
ShankerV
17 - Castor

Hi @markashman 

 

One way of doing this.

 

Current EPOCH time is,

ShankerV_0-1677590952445.png

 


DateTimeAdd('1970-01-01 00:00:00',[Unix Seconds],'seconds')

 

ShankerV_1-1677591066995.png

Many thanks

Shanker V

markashman
8 - Asteroid

Had to /1000 to handle milliseconds, but other than that worked fine, thanks

Labels