When user manually types the filter value (only date) in RadDateTimeEditor adds current time, so the filter value becomes - %data %current time.
And filtering gives the empty table, because of values in datetime columns have 00:00:00 time.
How to set time to 00:00:00 instead of using current?
P.S. If user chooses value with DateTimePicker then filter value is %data 00:00:00 and filtering works fine.
2 Answers, 1 is accepted
Hello, Marseille,
I would like to note that GridViewDateTimeColumn which is usually used for managing DateTime values in RadGridView, offers the FilteringMode property. Thus, you can change the way the dates in the column are filtered. The available options in the GridViewTimeFilteringMode enumeration are:
- Time - filter by time only
- Date - filter by date only
- DateTime = Time | Date - filtering by both date and time
I believe that setting the FilteringMode property to GridViewTimeFilteringMode.Date would fit your scenario.
Additional information about the settings that GridViewDateTimeColumn offers is available here: https://docs.telerik.com/devtools/winforms/controls/gridview/columns/column-types/gridviewdatetimecolumn
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Sr.
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