:: Forum >> Version 2 >>

Date Sort

My date columns don't sort properly. Using 2.0.2.

my date format is mm/dd/yyy but the sort is not in any type of order and the rows with dates are not even all together. I've tried feeding it an iso date format of yyyy-mm-dd and date doesn't show at all.

var obj = new AW.UI.Grid;
obj.setCellData(myCells);

//set column formats
var string = new AW.Formats.String;
var number = new AW.Formats.Number;
var date = new AW.Formats.Date;
date.setDataFormat("default");
date.setTextFormat("mm/dd/yy");
date.setErrorText(" ");

obj.setCellFormat([number, string, number, string, number, string, number, number, date, date, string, string, date]);

obj.sort(10, "descending");

document.write(obj);

Any help greatly appreciated.
kdc
Thursday, June 14, 2007
Adding:

date.setErrorValue(0);

fixed the problem.

Thanks,
kdc
kdc
Thursday, June 14, 2007



This topic is archived.

Back to support forum

Forum search