Date datafield timezone handling

[N.K.Participant]

Hi,

The jqxGrid is offsetting the date and time fields sent from the server to local time zone, i.e, the date and time sent from the server are converted from UTC (server time ) to local time zone.
Is there a way to disable this functionality and let the grid display exactly the same Date and time (UTC) as sent from server.

Thanks
N.K.

[Peter StoevKeymaster]

Hi N.K.,

It won’t convert it if your server code returns the Date String including the Time-zone information and you specify that in the Date data field’s definition. Example: { name: ‘SubmitDate’, type: ‘date’, format: “yyyy-MM-ddTHH:mm:ss-HH:mm” }

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[N.K.Participant]

Hi Peter,

Thanks for the reply, it worked as expected using the above code.

Regards,
N.K.

[kkParticipant]

Hi all,

I am not able to sort the date column in jqxgrid that i get from the server in the form of Date String including the Time-zone information . what would be the cause and what changes are required.
example – “Wed May 13 17:16:50 IST 2015″ ,”Tue May 19 19:14:43 IST 2015” , “Mon May 18 12:30:44 IST 2015”

It is not sorting properly …

[Peter StoevKeymaster]

Hi kk,

You should set the “format” to point exactly to your Date string’s Format and set the “type” to “date”.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[kkParticipant]

Hi Peter,

Can you explain it in detail as I have tried to set the “type” to “date” but still it is not sorting properly ..

and about format so can this format: “yyyy-MM-ddTHH:mm:ss-HH:mm” will work that you have mentioned above ..

Thanks

[kkParticipant]

Hi ,

Also I am getting date in format – “2015-05-18T14:21:25.221+05:30”

thnx

[Author]

Posts