Re: [xsl] Thanks and a Question

Subject: Re: [xsl] 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/

Current Thread