corelibraries-devexpress-dot-export-dot-xl-dot-xldategroupitem-cdde0cc8.md
Gets which part of the DateTime value is used in the filter criteria.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public XlDateTimeGroupingType GroupingType { get; }
Public ReadOnly Property GroupingType As XlDateTimeGroupingType
| Type | Description |
|---|---|
| XlDateTimeGroupingType |
An XlDateTimeGroupingType enumeration member.
|
Available values:
| Name | Description |
|---|---|
| Year |
Groups the DateTime values by year.
| | Month |
Groups the DateTime values by month.
| | Day |
Groups the DateTime values by day.
| | Hour |
Groups the DateTime values by hour.
| | Minute |
Groups the DateTime values by minute.
| | Second |
Groups the DateTime values by second.
|
Each filter value for a date and time filter is defined by an instance of the XlDateGroupItem class. The XlDateGroupItem.Value property specifies the base date or time value to filter by. The GroupingType property specifies the part of the DateTime value to use in the filter criteria.
For example, an XlDateGroupItem instance with the GroupingType set to XlDateTimeGroupingType.Month and the XlDateGroupItem.Value set to DateTime(2017, 1, 6) filters all DateTime values that occur in January, 2017.
See Also