Bootstrap Table: sort by date field

I am using this Bootstrap table plugin. But sorting by date is not working properly.

Here is the code:

<table class=" table-striped" id="table" data-toggle="table"

            <th data-field="expiry_date" data-sortable="true" scope="col"><?= 'expiry date' ?></th>

Date is in this format: d/m/y (17/7/14)

How I can fix it in order to sort dates properly?


You must use a custom sorter with “data-sorter” attribute like data-sorter="datesSorter"

Then to fit your needs :

function datesSorter(a, b) {
  if (new Date(a) < new Date(b)) return 1;
  if (new Date(a) > new Date(b)) return -1;
  return 0;

Leave a Reply

Your email address will not be published. Required fields are marked *