i was testing the Column menu filter function. and noticed that for the dates specifically the dropdown menu for isEquals to does not return the date choosen even if it exist. i tried for a date after and before as well incase of time storing error like midnight but that wasn't it. However the "is Before and Equals to" and the "is After and Equals to" work for getting the equals date.
is this a known issue or a bug? can i specifically remove that option from the drop down or make it not default is so how?
2 Answers, 1 is accepted
Hello, Eti,
The isEqual operator compares the time as well, as each date has a time portion in it.
I made an example with the column menu, date filtering and it is working as expected:
https://stackblitz.com/edit/react-ggv2sw?file=app%2Fmain.jsx
If the dates have a time portion that has to be disregarded, we can suggest programmatically setting it to 00:00:00 when the conversion from the ISO dates to JS dates is done.
Regards,
Stefan
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Rank 1
Hello Eti,
I would recommend using the JavaScipt setHours() method to set the hours, minutes and seconds to 0 before passing the data to the Grid. I've created another example to showcase how to use this specific method:
https://stackblitz.com/edit/react-ggv2sw-pw5jau?file=app%2Fmain.jsx
Hope this can be useful for your application.
Regards,
Krissy
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.