Date column shows one day behind only in one computer

Date column shows one day behind only in one computer

jstuardojstuardo Posts: 91Questions: 37Answers: 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

Answers

  • kthorngrenkthorngren Posts: 20,141Questions: 26Answers: 4,736

    My first thought is the browser. Is there a difference in browser type and version between the working and non-working?

    Kevin

  • mtdevmtdev Posts: 14Questions: 2Answers: 1

    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 ?

Sign In or Register to comment.