Date Conversions problem !!

Question

Hi all ,

I am very new to alteryx. I am trying to convert an unix  time stamp(Publishing date JavaScript equivalent of a DateTime
how many milliseconds have passed between now and the beginning of 1970: for example:1474315762000) to date in alteryx. I am getting all the data in from an API in json format and parsing it as string.

I need solution for

how to convert from unix time(data type :string) to date in alteryx! (FYI i tried datetimeadd, and did not work properly)

Any help would be appreciated

regards

Nagarjuin Srinivas

jdunkerley79 · Accepted Answer

Probably the easiest way it is to use a select tool to convert to an Int64.

You can then use a formula tool to convert to a datetime by adding seconds to 1970-01-01:

DateTimeAdd('1970-01-01',Field1/1000, 'Seconds')

Alteryx only stores dates to the nearest second so you need to keep that as a separate column.

Sample attached.

Nagarjunrao24 · Accepted Answer

jdunkerley79 Thank you for the solution. it worked

regards

Nagarjun Srinivas