officefileapi-devexpress-dot-spreadsheet-dot-dategrouping-ed523abf.md
Gets which part of the DateTime value is used in the criteria.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public DateTimeGroupingType GroupingType { get; }
Public ReadOnly Property GroupingType As DateTimeGroupingType
| Type | Description |
|---|---|
| DateTimeGroupingType |
A DateTimeGroupingType enumeration member.
|
Available values:
| Name | Description |
|---|---|
| None |
The DateTime values are not grouped.
| | 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.
|
The Grouping Type specifies the bottom interval in the DateTime value specified by the DateGrouping.Value property used to filter cell values. A DateGrouping instance with the GroupingType set to DateTimeGroupingType.Month and the Value set to DateTime(2015, 1, 6) filters all DateTime values which occur in January, 2015.
See Also