I have a data grid that displays data from a table. Some columns are of type "date", others are of type "smalldate". I have German locale set, that is why dates are shown this way: "dd.mm.yyyy". The property "FilterDateFormat" is not set.
When I select the filter for a date or smalldate column, I can choose "euqals", "less than" or "greater than". The actual value for the filter is then selected using the built-in date/time picker.
The problem is, that the filter is not working! If I select "less than 15.03.2022" for a column, after the filter got applied, I see records with "23.01.2025" in that column. That is not correct.
Why is the filter not applied? If I use the filter with text column, it works as expected.