:: Forum >>

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

YaronP
Thursday, September 21, 2006

This topic is archived.


Back to support forum

Forum search