I want to sort date in the jqgrid. Below is my code line.
Data.push({ label: 'Upload Date', name: 'UploadedDate', width: 300,formatter:'date', formatoptions: { srcformat: "d/m/Y", newformat: "d/m/Y" }});
I have also tried :
Data.push({ label: 'Upload Date', name: 'UploadedDate', width: 300, sorttype: 'date', sopt: ['cn'] });
The problem with 2nd option is that it sorts only with dd and not with month or year. Pls suggest.