Grid / Filtering data between two dates

Suite and Optimus Suite 6
#1

Hello,

In my grid, I have a column containing dates. I’m trying to filter data (rows) for which the date is between two dates (for example, getting only the rows with a date between “01/01/2020” and “01/03/2020”. I tried to apply a filter using the “compare” function found in the documentation (https://docs.dhtmlx.com/suite/grid__usage.html) but it doesn’t seem to be called? I think I don’t understand well what this function is doing. Did anyone already add this kind of filter ? Is there maybe another way to filter by a date interval ?
I found this function which works fine for one date but not two :
grid.data.filter(function(item) {
return item.Date <“07/01/2020”;
});
grid.data.load(“data”);

#2

I finally solved it this way: I have a form with to 2 datePicker, filling “start” and “end”. Then I use those var in this function :

    function applyFilter(start, end) {
	grid.data.filter(function(item) {
        dateSplit = start.split('/');
        date_s = "20"+dateSplit[2]+"-"+dateSplit[1]+"-"+dateSplit[0];            
        var date_start = new Date(date_s);

        dateSplit2 = end.split('/');
        date_e = "20"+dateSplit2[2]+"-"+dateSplit2[1]+"-"+dateSplit2[0];            
        var date_end = new Date(date_e);
    
        tmp = item.Date.split('/');
        d = tmp[2]+"-"+tmp[1]+"-"+tmp[0];
        var date_item = new Date(d);

        if( date_item >= date_start && date_item <= date_end){
            return item;
        } 
	});
    grid.data.load("data");            
}