Sorting date mm/dd/yy hh:mm:ss AM/PM in grid


I have a grid with a column with dates. For example:
09/18/06 03:33:03 PM
09/18/06 11:40:09 AM
09/18/06 08:00:02 AM
I try to sort this column but it doesn't sort them correctly. It put them in the following order:
09/18/06 03:33:03 PM
09/18/06 08:00:02 AM
09/18/06 11:40:09 AM

I tried using setCellData and date.dataToValue but it didn't help. I see that it convert it to the correct numeric value but it still seems to sort alphabetic.

Need urgent help with source code that can handle this.


September 21,

This topic is archived.

See also:

Back to support forum