Date column inside a grid. Date is decreasing by 1 on saving of grid.

[ajitParticipant]

Hi

I have a grid containing column for date, but it is decreasing by 1 on every save. Actually we are developing this website in India (here it is working fine), but client (is in USA) when they are doing it is showing this behavior.

Please help.
Thanks.

[Peter StoevKeymaster]

Hi ajit,

Make sure that you include the Time-Zone information when you get Dates from your Server and populate the Grid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[ajitParticipant]

Thanks for quick response.
But in my case the website will be viewed and manipulated from both India and USA (both have different time zone).
Please advice, what i need to do.

[Peter StoevKeymaster]

Hi ajit,

Yes, and that is the reason of your error. Most probably you don’t take into account the Time-Zone in your code and my suggestion is to implement your solution in such way that it takes into account the time-zone information, too.

jqxGrid stores Dates as JavaScript Date objects. If you wish to get the time-zone offset. Use the getTimezoneOffset method: var offset = new Date().getTimezoneOffset(); More info: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/getTimezoneOffset

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts