cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert date from JSON into Thingworx Date format

SOLVED
Highlighted
Level 1

How to convert date from JSON into Thingworx Date format

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to convert date from JSON into Thingworx Date format

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))

1 REPLY 1

Re: How to convert date from JSON into Thingworx Date format

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))