Suddenly the date excel filters on the grid dissapear

[Luis]

Hi,

I have implemented a GRID with Excel filters and everything is working as expected, but in the last two days some of the Date filters are not working, but as I said is random, if I refresh the page most of them works again... 

Just to confirm, there are 5 date filters, the problem is not in all! just randomly in two or three of the 5 date filters.

I am using the latest version, anyone with the same problem? i need some help :(

Regards

Luis

[Praveenkumar Gajendiran]

Hi Luis, 

Thanks for contacting Syncfusion support.  

We checked your query and provide information. Based on that we suspect your reported problem occurs if the column type is not properly set. 

If the first row of a column contains undefined or null then the column type needs to be defined(by default the column type is automatically assigned based on its first value) for that as with this initial row data value, then only the column type will be set and based on the column type the filtering and other Grid actions will be performed. 

So if null or undefined value is present for a column in the initial row data and column type is not set for that, then the type will be set as ‘null’ which causes problems as you reported. This is the Grid’s default behavior. So we suggest you to resolve this by setting the column type in-case the first row data has null or undefined value. 

More details on this can be checked in the below documentation and sample link, 

Documentation: https://ej2.syncfusion.com/documentation/grid/columns/#column-type

Sample: https://stackblitz.com/edit/qgnkgb?file=index.ts

Please get back to us if you need further assistance. 

Regards,
Praveenkumar G