When I use the excel like filters of equals, greater than, or greater than or equal to with date columns I find no matches.
My DateTime values bound to the column have 00:00:00.0000 as the time component, like 9/30/2008 00:00:00.00000. When I pick this date on the calendar control in the excel like filter popup it works fine, but if I pick Available Filters -> Equals (or greater than, or greater than or equal to) and enter 9/30/2008 then it does not match the 9/30/2008 00:00:00.00000 rows.
I have tried this with FilteringMode = Date and FilteringMode = All, but it does not seem to make a difference. It seems like equals etc. is comparing it to like 9/30/2008 00:00:01.00000 or something crazy like that.
Is there something I can do to get these equals etc. filters working?
Using version 2021.2.615.40