How to convert date from JSON into Thingworx Date format

[mfelton]

from a JSON file that is being fed into my service the date is formatted like this: "\/Date(1490609194000)\/"

How would i go about converting this into a format that Thingworx recognises as a DateTime?

Thanks

[jamesm1 · Accepted solution]

You just need the numeric value and then can return that as a DATETIME type. i.e.:

var dateStr = "\/Date(1490609194000)\/"

var date = dateStr.match(/[0-9]+/)[0]

result = date

you could also do:

var dateStr = "\/Date(1490609194000)\/"

var date = dateStr.match(/[0-9]+/)[0]

result = new Date(Number(date))