[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

dateGroupItem (Date Grouping)

This collection is used to express a group of dates or times which are used in an AutoFilter criteria. See parent element for an example. Values are always written in the calendar type of the first date encountered in the filter range, so that all subsequent dates, even when formatted or represented by other calendar types, can be correctly compared for the purposes of filtering.

Parent Elements

filters3.3.2.8)

 

Attributes

Description

dateTimeGrouping (Date Time Grouping)

Grouping level.

 

The possible values for this attribute are defined by the ST_DateTimeGrouping simple type (§3.18.23).

day (Day)

Day (1-31)

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

hour (Hour)

Hour (0-23)

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

minute (Minute)

Minute (0-59)

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

month (Month)

Month (1-12)

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

second (Second)

Second (0-59)

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

year (Year)

Year (4 digits)

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_DateGroupItem">

   <attribute name="year" type="xsd:unsignedShort" use="required"/>

   <attribute name="month" type="xsd:unsignedShort" use="optional"/>

   <attribute name="day" type="xsd:unsignedShort" use="optional"/>

   <attribute name="hour" type="xsd:unsignedShort" use="optional"/>

   <attribute name="minute" type="xsd:unsignedShort" use="optional"/>

   <attribute name="second" type="xsd:unsignedShort" use="optional"/>

   <attribute name="dateTimeGrouping" type="ST_DateTimeGrouping" use="required"/>

</complexType>