Share via

2.6.164 CT_RichDateGroupItem

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2017/richdata2

Referenced by: CT_RichFilters

This complex type specifies a group of dates or times which are used in a filter criteria associated with rich values. This complex type extends the base type CT_DateGroupItem ([[ISO/IEC29500-1:2016] section 18.3.2.4).

Attributes:

key: An ST_RichFilterKey (section 2.7.38) attribute that specifies the rich value key for which the filters is defined.

year: An unsignedShort ([XMLSCHEMA2/2] section 3.3.23) attribute that specifies the year (4 digits).

month: An unsignedShort ([XMLSCHEMA2/2] section 3.3.23) attribute that specifies the month (1-12).

day: An unsignedShort ([XMLSCHEMA2/2] section 3.3.23) attribute that specifies the day (1-31).

hour: An unsignedShort ([XMLSCHEMA2/2] section 3.3.23) attribute that specifies the hour (0-23).

minute: An unsignedShort ([XMLSCHEMA2/2] section 3.3.23) attribute that specifies the minute (0-59).

second: An unsignedShort ([XMLSCHEMA2/2] section 3.3.23) attribute that specifies the second (0-59).

dateTimeGrouping: An ST_DateTimeGrouping ([ISO/IEC29500-1:2016] section 18.18.22) attribute that specifies the grouping level.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_RichDateGroupItem">
   <xsd:complexContent>
     <xsd:extension base="x:CT_DateGroupItem">
       <xsd:attribute name="key" type="ST_RichFilterKey" use="optional"/>
     </xsd:extension>
   </xsd:complexContent>
 </xsd:complexType>

See section 5.20 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).