Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Date Format From Server Reports

zeb27
5 - Atom

Hello,

 

I am pulling data from the Alteryx report servers in order to better understand how Alteryx users at my company are using the tool and to control what they are uploading to the servers. Being said, using an Alteryx workflow I can clean up the CSV. files that the server generates and show different metrics on the workflows and users. I am trying to clean up date data but the issue is the form is difficult to interpret.

 

/Date(1545127289000+0000)/

 

This is an example of what should be a date, any ideas how to trouble shoot?  I don't really care what form the date is as long as it is something readable.

 

Thanks in advance.

1 REPLY 1
MichalM
Alteryx
Alteryx

@zeb27 

 

The format looks like unix timestamp which is expressed as seconds since 1970-01-01. Judging by the length of the number it looks like milliseconds rather than seconds. The value after + would be timezone adjustment.

 

Once you separate out the number (eg by using the Text-to-columns tool), you can use the below formula to turn it into date

 

 

DateTimeAdd("1970-01-01",[seconds]/1000,"seconds")

 

 

unix-timestamp1.png