Subject: Re: Thanks and a Question
From: Martin Honnen <Martin.Honnen@xxxxxx>
Date: Fri, 04 Jun 2010 17:20:38 +0200
|
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/
|
Cart
