DataTables JS does not sort date correctly in PHP application

Question

I was tasked to fix this table sorting in this PHP app. The table uses DataTable 1.10 to auto generate the datatable for the php blade.php file.

The data coming into the page uses the following format for the "Publish Date":

uploaded_at: "2018-01-02 00:00:00"

page.blade.php

<table class="table tbl_issue" cellspacing="0" style="border: 1px solid #e9ecef;border-radius: 4px;">
                        <thead>
                            <tr>
                                <th>Issue Title</th>
                                <th>Publish Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if(count($data['issues']))
                                @foreach($data['issues'] as $issue)
                                @if($issue->uploaded_at >= $data['starts_date'])
                                <tr>
                                    <td>
                                        {{$issue->name}}
                                    </td>
                                    <td>{{date('m/d/Y', strtotime($issue->uploaded_at))}}</td>
                                </tr>
                                @endif
                                @endforeach
                        </tbody>
                    </table>

$(document).ready(function(){
    $('.tbl_issue').DataTable();
});

When I click the auto-generated "publish date" filter, the dates are not sorted correctly. (images below)

As you can see, the 08/18/2016 date is always in the middle.

How can i get this sorting dates correctly?

thecoolestguyever123 · Accepted Answer · 2018-08-28 16:33:49Z

1

Try using the Datatables API to set that column as type date.

Example:

$('#example').dataTable( {
  "columns": [
      { "type": "string" },
      { "type": "date" },
  ]
} );

See reference:

https://datatables.net/reference/option/columns.type

edited Aug 28, 2018 at 16:33

answered Aug 26, 2018 at 22:06

thecoolestguyever123

9831 gold badge6 silver badges22 bronze badges

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

1 Comment

thecoolestguyever123 Over a year ago

Datatables SHOULD be able to detect it as a date though from the format you fed the table. You should check to see if there's padding on your date or anything by var_dumping it.

Collectives™ on Stack Overflow

DataTables JS does not sort date correctly in PHP application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related