Tony,

I spoke too soon. Your suggestion seemed to work, but I just realized that sorting was only functioning for certain cases where my displayed date values in the visible column are all the same year. Since I am not displaying year, I still cannot properly sort values from multiple years. The grid is correctly sorting by the hidden column at first, but not when I click the visible date column.

The SortArrayData() function for client-side data sets the column to be sorted based on ts.p.lastsort. In other words, it does not care about sortname. Do you have a suggestion for sorting a “local” dataset against the data in a column other than the one that is clicked?

Thanks,

David

Tony,

Thanks for the tip on using afterInsertRow for applying a formatting function to my data.

The sorting issue is definitely the tougher one to overcome, although I am hoping it is not too bad. I think that the easiest solution is to allow the sort event for a given column to key off of the data in another column. In my case, I have created a hidden column with the date values as milliseconds. If I could tell the visible date column to sort based on the values of the hidden column instead of the values in the column I click, my problems would be solved.

Thanks,

David