ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

How to convert /Date(1525730400000)// format to MM/dd/yyyy

Dennisklad1
8 - Asteroid

Hi everybody,

 

I am using the Download tool to request some data over an API call. For some reason the returned Dates are in following format:

/Date(2367568800000)/
/Date(2368512000000)/
/Date(2366956800000)/

 

Does anybody know how I can convert them to normal dates?

 

Thanks

PhilipMannering
14 - Magnetar
14 - Magnetar

Hi @Dennisklad1 

 

I think this does the trick...

Not sure if the number is milliseconds since 1900-01-01 or 1970-01-01. You might be able to edit as appropriate.

PhilipMannering_0-1618480881957.png

 

 

Thanks,

Philip

Dennisklad1
8 - Asteroid

Hm interesting. Thanks alot

danilang
17 - Castor
17 - Castor

Hi @Dennisklad1 

 

For a bit of background, the times that you see here are probably generated by unix systems and are know as Unix or Epoch time.  The Epoch started on 1970-01-01 00:00:00 and times are stored as the number of milliseconds since then.  

 

Dan  

Labels