I've got a flex grid which I'd like to sort by two columns - date and time. From what I've read about the control, the way to sort it is to select the column and select the sort method:

grid1.col = 1
grid1.sort = flexSortGenericAscending

I'm having two problems:

1) It doesn't seem to sort dates properly -- as soon as it hits the "/" character, it runs into a problem. For example, the data set {03/10/2000, 03/13/2000, 03/29/2000, 04/01/2000} results in {03/10/2000, 03/29/2000, 03/13/2000, 04/01/2000}. I'm not quite sure why this is... If the comparison is done as a string, the slash shouldn't cause a problem.

2) I also need it to sort by the time of the day (another column) in ascending order. I can sort by either column, but not by both columns (using one as a 'priority').

I tried to remedy this by combining both columns into an invisible column. 03/10/2000 17:39 would become: 031020001739. For some reason, it didn't sort properly.

Am I doing something wrong here or has anyone come across similar problems using the MSHFlexGrid control?

Any help would be greatly appreciated.