You can change the way the dates in the GridViewDateTimeColumn are filtered. The GridViewDateTimeColumn.FilteringMode property allows you to specify whether only the date part or the time part will be considered. Setting it to GridViewTimeFilteringMode.Date will allow filtering only by Dates.
Excel-like filtering is quite useful for filtering by picking up certain years. It is just necessary to change the default filter dialog with a RadListFilterPopup as it is illustrated below and then just check the desired year (or month, or day):
this.radGridView1.EnableFiltering = true;
this.radGridView1.ShowHeaderCellButtons = true;
GridViewDateTimeColumn dateTimeColumn = this.radGridView1.Columns["OrderDate"] as GridViewDateTimeColumn;
dateTimeColumn.FilteringMode = GridViewTimeFilteringMode.Date;
private void radGridView1_FilterPopupRequired(object sender, FilterPopupRequiredEventArgs e)
if (e.Column.Name == "OrderDate")
e.FilterPopup = new RadListFilterPopup(e.Column, true);
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Dess | Tech Support Engineer, Sr.
Progress is here for your business, like always. Read more
about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.