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