jqGrid Date format sorting in DD/MM/YYYY

383 Views Asked by At

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.

0

There are 0 best solutions below