date column sorting problem
The date I want to see in the grid is in dd-mmm-yyyy format. If I keep it in mm-dd-yyyy the sorting works fine, but I can't get it to work in the dd-mmm-yyyy format.
I guess I have to change the CellValue of that column with SetCellValue (and I could even provide a hidden column in the right format), but I need help with the last part of the puzzle.
Hope anyone can help?!