Sigma Grid Soring Issue for Date column

[Gowtham]

While sorting the date column in sigma grid, not sorted based on date. It is sorted like string column.

kindly suggest.

[steven]

Do a customized sorting. just like
http://www.sigmawidgets.com/products/sigma_grid2/demos/example_customized_sort.html

[Gowtham]

In this sample, The Score column is not sorting based on score values. please reply.

[steven]

Yes, teams which lose more appears before teams lose less. The following code just show you a way to implement your sorting rules.
{id: 'score' , header: "Score" , width :80,        sortFn :function(r1,r2){          arr1 = r1[1].split(":");          arr2 = r2[1].split(":");                 return (arr1[0]-arr1[1]) - (arr2[0]-arr2[1]);            } },
suppose you have a date with "MM/DD/YYYY" as formate. The code should go like
{id: 'date' , header: "Score" , width :80,        sortFn :function(r1,r2){          arr1 = r1["date_col"].split("/");          arr2 = r2["date_col"].split("/");          //compare year first          if(arr1[2]>arr2[2]) return 1;          if(arr1[2]<arr2[2]) return -1;          //compare month          if(arr1[1]>arr2[1]) return 1;          if(arr1[1]<arr2[1]) return -1;          //compare date          return arr1[1]-arr2[1]; } },

[Gowtham]

Thank you steven

[eWineGuy]

Perhaps I'm the only one having date sort troubles using your solution, but perhaps others are as well.  When I implement what you suggest, my grid dies and never displays.  Maybe I have a variable naming issue so perhaps a bit more explanation would be helpful.

For the ID named "date", you reference "date_col" in your custom sort script. Is this a reserved word?  I have an ID field named OrderDate.  Do I use (1) "date_col"   (2) "OrderDate_col" or (3) something else? 

I assume the data set Option data type is set to date ... {name : 'OrderDate' ,type: 'date' },

I even changed to use the ID of "date" as per your example and still my grid dies. I remove the custom sort and it's fine.

Comments or assistance welcome!

(newbie)

[dwlovell]

I think an easier solution is to just set the column type as int, then use the getSortValue() method overload on the column that uses new Date(thedate).getTime() to get the ticks since the zero date. Now the dates will be sorted appropriately without anything fancy.