Filtering Option "Datetime is not Defined"

zgoforth

Link to test case: https://jsfiddle.net/BeerusDev/mznL52p8/144/

So originally, I had created a plugin to filter the table to only show data that contained dates in that of the current week. Here it is:

$.fn.dataTable.ext.search.push(
    function( settings, searchData, index, rowData, counter ) {
        var now = moment();
        var monday = now.clone().weekday(1);
        var friday = now.clone().weekday(5);
        
        let mondayF = monday.format('MM/DD/YYYY');
        let fridayF = friday.format('MM/DD/YYYY');
        
        
        var sMonday = searchData[2];
        var sFriday = searchData[10];
        
        if (mondayF == sMonday && fridayF == sFriday) {
            return true;
        }
        return false;
    }
);

It worked perfectly, but unfortunately requirements changed and now I need to be able to filter through all the data, especially so people can look back at past weeks.

I implemented https://datatables.net/extensions/datetime/examples/integration/datatables.html, and it is giving me quite a bit of errors, as well as the calendar/date selector appear below the table? Lastly, the example searches for a value from one column, I want to find a couple of dates from the Monday-Friday columns. Like if they are in between the Monday & Friday Dates, show it.

colin

DateTime is now it's own independent library, so you'll need to import those files into your app too. Alternatively, just use the Download page,

Colin

zgoforth

@colin thanks I forgot to add the stylesheet as well as the script... I made sure to include those, and look at how the Date Range Filter selector is below the table, and nothing happens when I enter the two dates to search for, the table doesn't filter. Meanwhile, nothing is happening in console showing me any warnings or errors:
https://jsfiddle.net/BeerusDev/mznL52p8/150/