Date format and sorting

Hey Yaara,
had the same issue, found a solution here:
https://datatables.net/plug-ins/sorting/datetime-moment

Basically, the default supported date format is YYYY/MM/DD. In order to support a DD/MM/YYYY format you’d have to load moment.js & datetime-moment.js . If you’re using WordPress, you can enqueue them by adding this snippet to your functions.php (just be sure to place the JS codes in the right folder):

wp_enqueue_script( 'moment', '/js/moment.js', array ( 'jquery' ), 1.1, true);
wp_enqueue_script( 'datetime', '/js/datetime-moment.js', array ( 'moment' ), 1.1, true);

Then specify the format you want to support like this:

jQuery(document).ready(function($) { 
// needed for running jquery in a WordPress environment

$(document).ready(function() {
    $.fn.dataTable.moment( 'DD/MM/YYYY' );
    } );
});

Thanks, @lazarboy!

I tried what you suggested and it resulted in a corrupted functions.php ??
In wp_enqueue_script I tried several $src options but none of them worked (relative, full path, full url).
Is functions.php the right place?

Yikes! Sorry about that.

To avoid corrupting functions.php, try using a snippets plugin such as this one, which allows you to safely activate and deactivate pieces of code. Where did you put moment.js and datetime-moment.js? I put them in a “js” folder in my WP installation root directory, and it works fine.

And in case it wasn’t clear, the jQuery code should be called from a JavaScript file or added to the theme using a <script> tag, and NOT added as a snippet to functions.php… ??

Also, I stumbled upon another solution to the date format issue. Have a look at the “date-eu” type, it might be simpler.

Thank you @lazarboy!