JSON to Collection Weid Dates Issue

AdamOllerenshaw — Fri, 17 Jan 2020 11:29:00 GMT

Hi

So we have come across a strange issue with JSON to Collection action not formatting some date/times correctly - date format is I believe called epoch (example of our date string being... \/Date(1555372800000)\/)

Once we convert our string into a collection using the above, some dates are being formatted as 1 day in the past with a time of 23:00. The dates being correctly formatted have time of 00:00. Weirdly it seems to be based on Month - November to March show correct date with time 00:00, April to October are wrong showing date-1 and time 23:00.

Using the above example through an online checker (epochconverter.com) shows GMT date as 16 April 2019 00:00:00. This string runs through the JSON to collection and date that comes out is 15 April 2019 23:00:00

Note this is Version 6.4

Has anyone come across this? or have any ideas on where to start looking to address?

hope to hear back

Regards

------------------------------
Adam Ollerenshaw
Process Automation Modeller
Computershare
Europe/Bristol - UK
------------------------------

topic JSON to Collection Weid Dates Issue in Product Forum

JSON to Collection Weid Dates Issue