Last Updated: 08 Apr 2020 14:53 by ADMIN
Created on: 23 Jan 2020 15:11
Category: Grid
Type: Bug Report
Miliseconds break filter functionality in RadGrid with Excel Like Filtering
In a GridDateTimeColumn I have some value data with milliseconds like "2018-09-24 18:05:21.057"

Filtering with the milliseconds returns no results.

Then I remove milliseconds part "2018-09-24 18:05:21"

Filtering without that will return results.

Even with the EnableTimeIndependentFiltering property set to True, the milliseconds are not ignored, and the filtering mechanism doesn't find the records.
1 comment
Attila Antal
Posted on: 23 Jan 2020 15:30

Thank you for your time reporting this problem. The issue is confirmed to be a bug and we have logged it in our system.

We can suggest the following two options that might serve as a viable workaround:

Option 1: If milliseconds are just as important as the rest of the values, change the DateTime value to String instead.

Option 2: If the milliseconds doesn't matter but they come with the parsed date, you can use the Date property of the DateTime object to extract only the date such as Day, Month, tear, Hour, Minute and Seconds.

var dateWithMilliseconds = DateTime.Parse("2018-09-24 18:05:21.057"); // Output: 09/24/2018 18:05:21.057

var dateWithoutMilliSeconds = DateTime.Parse("2018-09-24 18:05:21.057").Date;  // Output: 09/24/2018 18:05:21