XlDateGroupItem.GroupingType Property

Gets which part of the DateTime value is used in the filter criteria.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v19.1.Core.dll

Declaration

C#

public XlDateTimeGroupingType GroupingType { get; }

VB.NET

Public ReadOnly Property GroupingType As XlDateTimeGroupingType

Property Value

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.

Remarks

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.