Date column shows one day behind only in one computer
Date column shows one day behind only in one computer
jstuardo
Posts: 104Questions: 41Answers: 0
This is strange and only happens in one computer.
The data come from an ajax source. One column contains a date which are transmitted from server to client this way: "/Date(86414400000)/".
Column rendering definition for DataTable is set to: render: $.fn.dataTable.render.moment('', 'DD/MM/YYYY')
Well... in one computer, the cell is shown incorrectly as 26/09/1972. In others, the date is shown correctly as 27/09/1972.
What may be causing this. Thanks
This question has an accepted answers - jump to answer
Answers
My first thought is the browser. Is there a difference in browser type and version between the working and non-working?
Kevin
Hello,
Perhaps you could check the default timezone of these browsers (and computers), by testing the value returned by :
moment(86414400, 'X')For me "Wed Sep 27 1972 05:00:00 GMT+0100 (Central European Standard Time)", ie. 27/09/2022, 05:00:00 PM
But in 'Pacific/Pago_Pago' timezone, it is 26/06/2022, 05:00:00 PM
And in 'Asia/Jakarta' timzone, it is 27/09/1972, 11:00:00 AM
That could be an explanation ?