Filtering older dates on DateTimeColumn

Hello, Stéphane,  

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):

        public RadForm1()
        {
            InitializeComponent();
            this.radGridView1.EnableFiltering = true;
            this.radGridView1.ShowHeaderCellButtons = true; // enable Excel-like filtering
            GridViewDateTimeColumn dateTimeColumn = this.radGridView1.Columns["OrderDate"] as GridViewDateTimeColumn;
            dateTimeColumn.FilteringMode = GridViewTimeFilteringMode.Date;
            this.radGridView1.FilterPopupRequired+=radGridView1_FilterPopupRequired;
        }

        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. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Hi Dess,

Thanks for the answer.  The data coming from my datatable was a String, so the grid displayed it as a string as well even though it was datetime column

Hello, Stéphane,

I hope that you find the previous reply helpful and if you have a GridViewDateTimeColumn with proper DateTime values stored in the cells, you will be able to filter easily by years via the RadListFilterPopup.

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik