Share via

2.2.4.13 AutoFilterDateNodeInfo

  • Article

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

Specifies how AutoFilter filter date values are filtered by the protocol server.

 <xs:complexType name="AutoFilterDateNodeInfo">
   <xs:sequence>
     <xs:element minOccurs="1" maxOccurs="1" name="NodeType" type="tns:AutoFilterDateNodeType"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Year" type="xs:short"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Month" type="xs:short"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Day" type="xs:short"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Hour" type="xs:short"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Minute" type="xs:short"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Second" type="xs:short"/>
   </xs:sequence>
 </xs:complexType>

NodeType: The type of the node. Specifies the element that is included in the filter as specified in section 2.2.5.2.

Year: The year part of a date. MUST be greater than or equal to 1900 and less than or equal to 9999.

Month: The month part of a date. MUST be greater than or equal to zero and less than or equal to 12. The protocol server MUST ignore the value zero ("0").

Day: The day part of a date. MUST be greater than or equal to zero and less than or equal to 31, and SHOULD<2> be a valid day of the month for the year specified in the Year element and month specified in the Month element. The protocol server SHOULD<3> ignore the value zero ("0").

Hour: The hour part of a date. MUST be greater than or equal to zero and less than or equal to 23.

Minute: The minute part of a date. MUST be greater than or equal to zero and less than or equal to 59.

Second: The second part of a date. MUST be greater than or equal to zero and less than or equal to 59.