Grid sortting date format

[SivaParticipant]

Hi Team,

In my grid one of the column have date column and the format is ‘Thursday, August 17, 2015 11:02:08 AM’. I want to sort this by column sortting, can you please help?

Thanks in advance.

[adminKeymaster]

Hi Siva,

The Date format is not important, because the Grid always sorts by JavaScript Date objects. It internally works only with JavaScript Dates for Date columns. Demo: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/sorting.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[SivaParticipant]

Hi,
I tried this too, but from my side is different. we are getting the timestamp and convert into date as like ‘Thursday, August 17, 2015 11:02:08 AM’. In the date column we marked the datatype field as type: ‘date’ and also the cellformat: ‘yyyy-MM-dd’ or ”dddd, MMMM dd, yyyy h:mm:ss tt’.

Still my sorting is not working as expected.

[Peter StoevKeymaster]

Hi Siva,

Columns do not have type property. source object’s datafields array have. I suggest you to look at the jqxGrid>Data Sources help topic on the Documentation page to learn how to data bind jqxGrid to a data source. There you will find information about Date columns as well.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[SivaParticipant]

hi peter,

datafields: [
{ name: ‘Date’, type: ‘date’ },
{ name: ‘Freight’, type: ‘float’ },
{ name: ‘ShipName’, type: ‘string’ }
]

columns have ‘type’, this code taken from your example(data source).

[Peter StoevKeymaster]

Hi Siva,

Look at the help topic, please. For you data source, it may be necessary to set the “format”, too. If after reading the topic, you still did not solve your problem, then send me a https://www.jseditor.io/ example.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts