Jqgrid sort date column

Question

I am using ASP.NET MVC with JQGrid.

Now the problem is, how can I sort a column datein JQGrid? Any ideas?

Answer 1

On the client side, you can use the sorttype and datefmt parameters to specify jqGrid to sort these columns.

For example:

sorttype: "date", datefmt: "M d, Y at h:i"

Answer 2

I am doing a sort on a database server. I elaborated on how I do this in a series of blog posts , and you can download a demo solution (which does not use DB, but can still sort by date on the server side).