DataTables

DataTables Examples

by Muthuraman B

HTML

<link rel="stylesheet" href="//cdn.datatables.net/1.10.0/css/jquery.dataTables.css">
<script src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.js"></script>
<script src="https://cdn.datatables.net/rowreorder/1.0.0/js/dataTables.rowReorder.js"></script>
<link rel="stylesheet" href="http://cdn.datatables.net/rowreorder/1.0.0/css/rowReorder.dataTables.css">
<table id="example">
        <thead>
            <tr>
                <th>date</th>
            </tr>
        </thead>
        <tbody>
<tr><td>12/12/2012</td>        
<tr><td>12/12/2016</td>
<tr><td>12/1/2015</td>
<tr><td>11/01/2017</td>
<tr><td>5/5/2013</td>
        </tbody>
    </table>

JavaScript

jQuery.extend( jQuery.fn.dataTableExt.oSort, {
  "ddMmYyyy-pre" : function(a) {
   	 a = a.split('/');
     if (a.length < 2) return 0;
     return Date.parse(a[2] + '-' + a[0] + '-' + a[1])
  },
  "ddMmYyyy-asc" : function ( a, b ) {
     return ((a < b) ? -1 : ((a > b) ? 1 : 0));
  },
  "ddMmYyyy-desc": function ( a, b ) {
     return ((a < b) ? 1 : ((a > b) ? -1 : 0));
  }
})    
var table = $('#example').DataTable({
	columnDefs : [
     { targets: 0, type: "ddMmYyyy" }
  ]
})