Grid / Filtering data between two dates


#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”);