jQuery UI Widgets Forums Grid exportview time offset issue

This topic contains 1 reply, has 2 voices, and was last updated by  admin 3 months, 2 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • exportview time offset issue #134359

    jlarue
    Participant

    I am using exportView to create an excel spreadsheet with the grid. The grid contains a date/time column that I am formatting as hh:mm tt. When the data is rendered in excel, the time in that column is being offset by +5 hours.

    for example, the value coming from the server is 2024-02-20T11:51:29.893. it is being sent to excel as 4:51PM.

    See a working example here https://jseditor.io/?key=boilerplate.

    Do i have any control over how this behaves?

    thank you!

    exportview time offset issue #134361

    admin
    Keymaster

    Hi jlarue,

    This is the time-zone difference between your time zone and the time-zone used by Excel – the UTC time zone. The Grid displays your dates in your time zone while excel does not.

    Regards,
    Peter

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.