Datatable Sort By Date Correctly

I'm using Django framework for my web site but to show info I use the plugin Datatable so one column show date info, the format that is used to show the date is like May. 6, 2017 s

Solution 1:

When defining the columns of your DataTable, you need to specify the render callback as in the example below:

        columns: [
            {
                title: "Date",
                data: "yourDateRef",
                render: function(data, type, row) {
                    if (type == "display") {
                        return prettyFormat(data);
                    }
                    else {
                        returndata;
                    }
                }
            },
            ...

Basically, DataTables calls the render callback to display the data (type=="display"), but also when the data needs to be sorted (type=="sort"), or filtered (type=="filter").

This allows you to control how a given field is displayed, but also sorted and filtered.

More information: https://datatables.net/reference/option/columns.render

Hope this helps!