Community Tip - You can change your system assigned username to something more personal in your community settings. X
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
Solved! Go to 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))
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))