[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Collapse]Spreadsheet
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Shapes
    Printing
    Protection
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Services
    Themes and Templates
   [Expand]Shortcuts
   [Collapse]Examples
    [Expand]Files
    [Expand]Workbooks
    [Expand]Worksheet
    [Expand]Rows and Columns
    [Expand]Cells
    [Expand]Formulas
    [Expand]Data Binding
    [Expand]Formatting Cells
    [Expand]Conditional Formatting
    [Expand]Group Data
    [Collapse]Filter Data
      How to: Enable Filtering
      How to: Filter by Cell Values
      How to: Filter by Date Values
      How to: Apply a Custom Date Filter
      How to: Apply a Custom Text Filter
      How to: Apply a Custom Number Filter
      How to: Apply a Dynamic Filter
      How to: Filter Top or Bottom Ranked Values
      How to: Sort Data in the Filtered Range
      How to: Reapply a Filter
      How to: Clear a Filter
    [Expand]Tables
    [Expand]Pivot Tables
    [Expand]Printing
    [Expand]Pictures
    [Expand]Charts
    [Expand]Protection
    [Expand]Mail Merge
    [Expand]Cell Templates
    [Expand]Customization
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Filter by Date Values

This example demonstrates how to filter date and time values in a column.

  1. Turn on the filtering functionality for the required range, as described in the How to: Enable Filtering example.

  2. Use the AutoFilterBase.Columns property of the SheetAutoFilter object to get a collection of columns in the filtered range (the AutoFilterColumnCollection object). Each column in the collection is defined by the AutoFilterColumn object, which provides basic methods for data filtering. To filter data in a particular column, get access to this column by its index in the AutoFilterColumnCollection collection.

  3. Create a list of date and time values, which should be used in the filter criteria. Each filter value for a date and time filter is defined by an instance of the DateGrouping class. Thus, to perform filtering, initialize an instance of the DateGrouping class using the DateGrouping.DateGrouping constructor with the following parameters.

    • A System.DateTime value that specifies the base date or time value to filter by.

    • A DateTimeGroupingType enumeration member that specifies the part of the System.DateTime value to be used in the filter criteria.

    In this example, the DateGrouping instance with the DateGrouping.Value set to DateTime(2015, 1, 1) and DateGrouping.GroupingType set to DateTimeGroupingType.Month is used to display all reporting dates occurring in January of 2015.

  4. To apply a date filter, call the AutoFilterColumn.ApplyFilterCriteria method and pass the created list of date grouping items as a parameter.

    If a column you wish to filter contains the mixed types of data, you can include additional values to the filter criteria. To do this, use the ApplyFilterCriteria method overload with two parameters and pass the FilterValue object, containing required cell values, as the first parameter.

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E4944.

Is this topic helpful?​​​​​​​