jQuery Grid Plugin - jqGrid - Topic: Question of Date Columns http://www.trirand.com/blog/?page_id=393/help/question-of-date-columns Simple:Press Version 5.7.5.3 tony on Question of Date Columns http://www.trirand.com/blog/?page_id=393/help/question-of-date-columns#p6291 Help http://www.trirand.com/blog/?page_id=393/help/question-of-date-columns#p6291 Hello,

Local sorting is performed only on numeric date fields. It is a known limitation. Supporting a full range of date sorting including diffrent language setting requiere a code bigger than jqGrid. In order to resolve the problem add a hidden column with numbers or other acceptable date format and perform the sort on that column when you try to sort on the other one. Use onSortCol event for this purpose.

Regards

Tony

]]> Sat, 25 Apr 2009 07:06:04 +0300 Jim P on Question of Date Columns http://www.trirand.com/blog/?page_id=393/help/question-of-date-columns#p6263 Help http://www.trirand.com/blog/?page_id=393/help/question-of-date-columns#p6263 Tony,

The sorting of my date columns is not working.  The sorting is done at the db based on the columns passed.   I've played with the formating and have removed the formating from the colModel and it still acts the same.

My source date is 14-NOV-06 00.00.00.

In php this would be:  d-M-y H:i:s

Is this a know problem?

Thanks, Jim

]]> Fri, 24 Apr 2009 14:52:47 +0300