Sort Date

This sort function does not seem to work with my date format which is
1/01/2004 no leading 0 for month. Is there anything that could be
changed so it would sort properly. It is part of a Table Sort
script(sorttable.js) Thanks


function ts_sort_date(a,b) {
// y2k notes: two digit years less than 50 are treated as 20XX,
greater than 50 are treated as 19XX
aa = ts_getInnerText(a.cells[SORT_C*OLUMN_INDEX]);
bb = ts_getInnerText(b.cells[SORT_C*OLUMN_INDEX]);
if (aa.length == 10) {
dt1 = aa.substr(6,4)+aa.substr(3,2)+*aa.substr(0,2);
} else {
yr = aa.substr(6,2);
if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }

dt1 = yr+aa.substr(3,2)+aa.substr(0,*2);
}
if (bb.length == 10) {
dt2 = bb.substr(6,4)+bb.substr(3,2)+*bb.substr(0,2);
} else {
yr = bb.substr(6,2);
if (parseInt(yr) < 50) { yr = '20'+yr; } else { yr = '19'+yr; }

dt2 = yr+bb.substr(3,2)+bb.substr(0,*2);
}
if (dt1==dt2) return 0;
if (dt1<dt2) return -1;
return 1;

On 2005-08-19, jeffsal <jeffsal (AT) charter (DOT) net> wrote:

This sort function does not seem to work with my date format which is
1/01/2004 no leading 0 for month. Is there anything that could be
changed so it would sort properly. It is part of a Table Sort
script(sorttable.js) Thanks

break the date into numbers not substrings.



--

Bye.
Jasen