3.2.0

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
June 14,
Adding:

date.setErrorValue(0);

fixed the problem.

Thanks,
kdc
kdc
June 14,

This topic is archived.

See also:


Back to support forum