If I have the following XML input:

<schedule>
<time>
<start>2010-11-07T22:00:00-06:00</start>
<ending>2010-11-07T23:00:00-06:00</ending>
<value>2.0</value>
</time>
<time>
<start>2010-11-07T23:00:00-06:00</start>
<ending>2010-11-08T00:00:00-06:00</ending>
<value>8.0</value>
</time>
<time>
<start>2010-11-07T02:00:00-06:00</start>
<ending>2010-11-07T03:00:00-06:00</ending>
<value>7.0</value>
</time>
</schedule>

The problem I am having is that the above XML defines a set of times that are not in sequential order and I need to select the last <time> for that day. In this case, I would want to select the 2nd <time> node.

Any help is greatly appreciated.

Thanks.

You can use max(time/ending/xs:dateTime(.)), or you can sort time element using

<xsl:sort select="xs:dateTime(ending)"/>

and choose the last.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference