How to sort date column in datatable jquery api?

Question

I am using datatable jquery api. I have a table which contains a date column, of which, data are in text format i.e. August 2nd, 2016. Here, the column is sorted in alphabetical order not according to the dates. What should I do ?

user7665578 · Accepted Answer · 2017-03-06 10:21:12Z

2

First, convert the dates using following line of code.

$timeStamp = strtotime('August 2nd, 2016');

Then, in the date column in your table, use this line of code.

<td data-order="<?php echo $timeStamp; ?>">August 2nd, 2016</td>

answered Mar 6, 2017 at 10:21

user7665578

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

Comments

cbalakus · Accepted Answer · 2017-03-06 10:22:30Z

2

try this in aoColumns;

        {
            sTitle: "Date", mData: "StartTime", mRender: function (data) {
                return data == null ? "" : '<span style="display:none;">' + new Date(data).getTime() + '</span>' + new Date(data).toLocaleString();
            }
        },

answered Mar 6, 2017 at 10:22

cbalakus

6369 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to sort date column in datatable jquery api?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related