Problem with sorting date and time

Hi,

I have a grid which has fourth column display the date and time. The column has the format as "02/15/08 11:15:48"

In my code, it has the date converter:
var date = new AW.Formats.Date;
date.setDataFormat("RFC822");

And enable the correct date sorting for the fouth column:
gridObject.setCellFormat(date, 3);


When I clicked on the grid header of the date/time column, it only sorted by the date and didn't sort by time. If I have rows of data with same date and different time, it's not sorting at all.

I also tried date.setDataFormat("ISO8601"), which is also not working.

Thank you.

Can anybody help?

Hi,

I am also have the same problem, please help me too.

You assign data using setCellText() method then you should use matching format in the setTextFormat() -

date.setTextFormat("mm/dd/yy hh:mm:ss");

http://www.activewidgets.com/aw.formats.date/settextformat.html