Answers

• rf1234 Posts: 2,808Questions: 85Answers: 406

  May 2018 Answer ✓

  That looks fine. Do you have rows in the table that do not contain a valid date? If it is likely not to work. This post has a couple of valuable hints:
  https://datatables.net/forums/discussion/49621
• allan Posts: 61,744Questions: 1Answers: 10,111 Site admin

  June 2018 Answer ✓

  We'd really need a link to a page showing the issue. The error suggests that one or more data points in the column don't match the date format given.

  Allan
• jwa Posts: 4Questions: 2Answers: 0

  June 2018

  There was indeed an invalid date in the data. The item didn't show up in the table at all, so I didn't notice before. Thank you for your help!
• rf1234 Posts: 2,808Questions: 85Answers: 406

  June 2018

  Maybe relevant for you @jwa or somebody else. I just had to modify the date time plug in to also handle non date values. This is what I did to include a row with totals into one of my tables. By returning a high date in case the totals row is hit I make sure the totals stay at the bottom when ordering ascending and vice versa.

  (function (factory) {
      if (typeof define === "function" && define.amd) {
          define(["jquery", "moment", "datatables.net"], factory);
      } else {
          factory(jQuery, moment);
      }
  }(function ($, moment) {
   
  $.fn.dataTable.moment = function ( format, locale ) {
      var types = $.fn.dataTable.ext.type;
   
      // Add type detection
      types.detect.unshift( function ( d ) {
          if ( d ) {
              // Strip HTML tags and newline characters if possible
              if ( d.replace ) {
                  d = d.replace(/(<.*?>)|(\r?\n|\r)/g, '');
              }
   
              // Strip out surrounding white space
              d = $.trim( d );
          }
   
          // Null and empty values are acceptable
          if ( d === '' || d === null || d === "Summen per Laufzeitende" ||
                                         d === "Totals"                      ) {
              return 'moment-'+format;
          }
   
          return moment( d, format, locale, true ).isValid() ?
              'moment-'+format :
              null;
      } );
   
      // Add sorting method - use an integer for the sorting
      types.order[ 'moment-'+format+'-pre' ] = function ( d ) {
          if ( d ) {
              
              if ( d === "Summen per Laufzeitende" ) {
                  d = "31.12.2999";
              }
              if ( d === "Totals" ) {
                  d = "31/12/2999";
              }
              // Strip HTML tags and newline characters if possible
              if ( d.replace ) {
                  d = d.replace(/(<.*?>)|(\r?\n|\r)/g, '');
              }
   
              // Strip out surrounding white space
              d = $.trim( d );
          }
           
          return !moment(d, format, locale, true).isValid() ?
              Infinity :
              parseInt( moment( d, format, locale, true ).format( 'x' ), 10 );
      };
  };
   
  }));
  
• nikhil_gyan Posts: 1Questions: 0Answers: 0

  October 2018

  Try this,

  // "sType": "date" TO SPECIFY SORTING IS APPLICABLE ON DATE
  "aoColumns": [
  null,
  null,
  null,
  null,
  {"sType": "date"},
  null
  ]