DataTables - data-order

by Faisal Khan Janjua

HTML

<link rel="stylesheet" href="https://cdn.datatables.net/1.10.7/css/jquery.dataTables.css">
<script src="https://cdn.datatables.net/1.10.7/js/jquery.dataTables.js"></script>
<table id="example">
  <thead>
    <tr>
      <th>value</th>
    </tr>
  </thead>
  <tbody>
    <tr><td>08/10/2018</td></tr>
    <tr><td>08/11/2018</td></tr>
    <tr><td>14/01/2019</td></tr>
    <tr><td>14/12/2018</td></tr>
    <tr><td>08/02/2019</td></tr>
    <tr><td>08/09/2018</td></tr>
    <tr><td>26/08/2018</td></tr>
    <tr><td>08/12/2018</td></tr>
  </tbody>
</table>

JavaScript

$(document).ready(function (){
  var table = $('#example').DataTable({
  	aaSorting: [], // disable Default Sorting on first Column
  });

  var nthEle = 1; // changing col # from 0 to 1
  jQuery('#example tbody tr td:nth-child('+nthEle+')').each(function(j){
    var rearrange = jQuery(this).text().split("/").reverse().join("").replace('/','');
    console.log(jQuery(this).text() + " => " + rearrange);
    jQuery(this).prepend('<span style="display:none;">'+rearrange+'</span>');
    table.cell(jQuery(this)).invalidate();
  });
});