Sorting date mm/dd/yy hh:mm:ss AM/PM in grid
Hi,
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.
Thanks,
Yaron
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.
Thanks,
Yaron
YaronP
September 21,