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

You can do that easy.

Use onSortCol (this event fires before sorting)

onSortCol : function (colname, colindex) {

if(colname == “visible_col”) {

$(“#mygrid”).setGridParam({sortname:”hidden_col”});

//no need to use triger reloadgrid

}

}

The only missing part here is a sorting image

jqGrid is flexible

Best Regards

Tony