Alteryx API Date Format

[Link86]

Hi,

I am pulling from the Alteryx Admin API to obtain a list of workflow. I am getting a strange date output for uploadDate: /Date(1469209240118)/. Does anyone know how to convert this to something that is human readable?

Thanks in advance.

[Luke_C · Accepted solution]

Hi @Link86 

It looks like this is unix time, likely milliseconds since 1970, I tried the below and came out with 7/22/2016. Is this a date you'd expect?

datetimeadd('1970-01-01', ([Field1]/1000),'seconds')

[Link86]

Awesome! Yes this is exactly the correct date. Thank you.