Answers

• Moiz Posts: 32Questions: 5Answers: 1

  December 2019

  Brother, @colin Any guidance?
• kthorngren Posts: 22,299Questions: 26Answers: 5,127

  December 2019 Answer ✓

  There are a few problems with your code

  The first problem is this error in the browser's console:

  Uncaught TypeError: $.fn.dataTable.moment is not a function

  The datetime-moment.js requires moment.js so moment.js needs to be loaded first, like this:

      <script src="//cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.js"></script>
      <script src="//cdn.datatables.net/plug-ins/1.10.20/sorting/datetime-moment.js"></script>
  

  The second problem is the format ($.fn.dataTable.moment( 'DD/MM/YYYY' );) needs to be defined before initializing Datatables.

  Third problem is you are loading datetime-moment.js and you copied the code from datetime-moment.js into the Javascript.

  Forth problem is that the columns have type: 'date' defined for the search plugin function to work. In order for the datetime-moment plugin to work it needs to set the column type using this code:

  $.fn.dataTable.ext.type.detect.unshift( function ( d ) {
      return moment( d, format, locale, true ).isValid() ?
          'moment-'+format :
          null;
  } );
  

  Now you need to remove the type: 'date' option and use the type assigned by the plugin in your search plugin. Datatables won't set the type using type but using sType. The if (col.type == "moment-DD/MM/YYYY") needs to change to if (col.sType == "moment-DD/MM/YYYY"). With this solution you won't be able to use the type to differentiate the columns in the plugin but will need to use the column number.

  Here is the updated example:
  http://live.datatables.net/kilayuce/10/edit

  Kevin
• Moiz Posts: 32Questions: 5Answers: 1

  December 2019

  Well, that's a lot of errors. Thanks brother, Kevin!