jquery datatable datetime column sorting

Question

I am using Jquery DataTables in one of my ASP.NET MVC project. My listing pages contains DateTime columns like CreateOn, LastUpdatedOn etc.

I want to enable sorting on these DateTime columns but the problem is that the DisplayFormat and the data on which I want to sort is different.

Means I want to sort the data by keeping time component of DateTime column but I don't want to display time component.

I used the Ultimate DateTime Sorting Plugin but I can't figure out option in that plugin.

Can anyone please help me?

Salman Shahid · Accepted Answer · 2015-10-20 07:27:47Z

4

Jquery datatables uses data-order attribute in td to order. To order datetime column use this technique that i have used and working fine for me convert your date in seconds then put that in data-order

See the image for more explanation

answered Oct 20, 2015 at 7:27

Salman Shahid

3184 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1