Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here
SOLVED

Date Format From Server Reports

Highlighted
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.

Highlighted
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