jQWidgets Forums

jQuery UI Widgets Forums Grid Date value not correct

Tagged: 

This topic contains 2 replies, has 2 voices, and was last updated by  bionets 10 years, 9 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • Date value not correct #59883

    bionets
    Participant

    I have a date field from database with a value of “2014-07-07” but when rendered on the grid the value becomes July 06, 2014. I have already checked the fetched data it is “2014-07-07” its just when it is rendered it becomes July 06, 2014.

    Hope to hear from you soon.

    Thanks

    Date value not correct #59884

    Peter Stoev
    Keymaster

    Hi bionets,

    The problem is that your Server and Client are in different Time Zones. Return to the Client your Date including Time Zone information and define the format setting of the “date” data field and everything will be correct. The problem which you observe is not a problem, but how JavaScript Date object works. It parses a Date String like “2014-07-07” to your Local Time Zone and if that string includes Time Zone information it will parse it to the specific Time Zone.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com/

    Date value not correct #59886

    bionets
    Participant

    Hi Pete,

    It’s okay now. Thank you for your help.

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

You must be logged in to reply to this topic.