:: Forum >>

Problem with sorting date and time


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;

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.
Monday, January 5, 2009
Can anybody help?
Tuesday, January 6, 2009

I am also have the same problem, please help me too.
Tuesday, January 6, 2009
You assign data using setCellText() method then you should use matching format in the setTextFormat() -

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

Alex (ActiveWidgets)
Wednesday, January 7, 2009

This topic is archived.

Back to support forum

Forum search