Webix Datatable ExcelFilter with mode Date is not working properly

Webix JS
1

Hello @NatashaS @Natalia_Shilova
When I have excelFilter in combination with mode Date, the filter is not working as expected.
https://snippet.webix.com/16h8cera

2

Hello Harshvardhan_Gaddam

In your event_date property you should use the date object instead of string. To convert string to date object you can use scheme property where you can map through the items and convert date strings into date objects:

 scheme:{
    $init:function(obj){
      if (obj.event_date) {
        obj.event_date = new Date(obj.event_date);
        obj.event_date.setHours(0,0,0,0);
      }
    } 
  }

Also to apply to dates the format you need use format:webix.Date.dateToStr(“%Y-%m-%d”).

Please check the example: Code Snippet