Start Building Professional
Web Apps Today

Custom sorting strange problem

Hello,

I have a very strange probelm with custom sorting - its driving me mad as I cannot see why it is happening? The column has a date format of the following.

dd/mm/yyyy hh:ii:ss

i.e.

31/01/2008 05:01:09

my custom sorting code is thus.

    mygrid.setCustomSorting(function(a,b,order){

    var aparts= a.split(" ");
    var datepart=aparts[0].split("/");
    var timepart=aparts[1].split(":");
    var adate=new Date(datepart[2], datepart[1], datepart[0], timepart[0], timepart[1], timepart[2]);
    
    var bparts= b.split(" ");
    var datepartb=bparts[0].split("/");
    var timepartb=bparts[1].split(":");
    var bdate=new Date(datepartb[2], datepartb[1], datepartb[0], timepartb[0], timepartb[1], timepartb[2]);
            

if (order=="asc") return (adate>bdate?1:-1);
else return (adate<bdate?1:-1);

},i);

this appeasr to have been working fine until a few days ago somebody noticed the following in the list when sorted asc

02/02/2008 05:00:11
31/01/2008 05:01:09
02/02/2008 05:05:55

which is obviously wrong - its seems to be the only one that is but I cannot for the life of me see why it should be there? Is there something glaring that I am missing?

Scott

The Date object expect that month and date will be a zero based numbers, so you need to use

var adate=new Date(datepart[2]-1, datepart[1]-1, datepart[0], timepart[0], timepart[1], timepart[2]);
....
var bdate=new Date(datepartb[2]-1, datepartb[1]-1, datepartb[0], timepartb[0], timepartb[1], timepartb[2]);