Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

EPOCH Dates

markashman
9 - Comet

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
9 - Comet

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

Labels
Top Solution Authors