Thanks.

Since ISO_DATES are sortable,

exists(//CASHFLOW[UPDAT_TIME gt parent::LEG/UPDAT_TIME])

Is sufficient.

Thanks for the pointer

Nick

On Fri, Jun 4, 2010 at 4:20 PM, Martin Honnen <Martin.Honnen@xxxxxx> wrote:
> Nick Leaton wrote:
>
>
>>  <MESSAGE>
>>    <TRADE>
>>      <UPDAT_TIME>2010-05-07 15:08:15</UPDAT_TIME>
>>        <LEG>
>>          <UPDAT_TIME>2010-05-07 13:57:39</UPDAT_TIME>
>>          <CASHFLOW>
>>            <UPDAT_TIME>2010-05-07 14:00:02</UPDAT_TIME>
>>          </CASHFLOW>
>>          <CASHFLOW>
>>            <UPDAT_TIME>2010-05-07 14:00:02</UPDAT_TIME>
>>          </CASHFLOW>
>>        </LEG>
>>      </INSTRUMENT>
>>    </TRADE>
>>  </MESSAGE>
>>
>>
>> I would like to test to see if there exists an UPDAT_TIME on any
>> cashflow that is greater than the UPDAT_TIME on the containing leg.
>
> Do you use XSLT 2.0 or 1.0? 2.0 can do dateTime comparison (although you
> need to replace your format first from
>  2010-05-07 14:00:02
> to
>  2010-05-07T14:00:02
> ):
>
>  exists(//CASHFLOW[xs:dateTime(replace(UPDAT_TIME, ' ', 'T')) gt
> xs:dateTime(replace(parent::LEG/UPDAT_TIME, ' ', 'T'))])
>
>
> --
>
>        Martin Honnen
>        http://msmvps.com/blogs/martin_honnen/
>
>



--
Nick