David,
Thank you for this. One of the big difference between jqGrid and others is the speed. This property is at first place. But having this we do not have a ton of other properies that nobody will use. We have a methods for customising this – i.e with a little programing you can achieve this. I recommend you to use afterInsertRow event and setCell method. The only thinng that you should do is to write your own date formater. The code should something like this:
afterInsertRow : function(rowid, datarow) {
// here is the code to format your date something like
mynewdate = customfunc(datarow.mydate);
$(”#mygrid”).setCell(rowid,'mydate',mynewdate);
}
The clear solution here is that the date should be formated server side
Now about the sorting. Currently jqGrid support sorting of dates only if they are numbers. I think that this shuld be corrected and mybe will be done soon.
Best Regards
Tony
