Re: Thanks and a Question

Play the video

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/

Current Thread
Thanks and a Question Nick Leaton - 4 Jun 2010 15:12:04 -0000 Martin Honnen - 4 Jun 2010 15:21:14 -0000 <= Nick Leaton - 4 Jun 2010 15:29:16 -0000

<- Previous	Index	Next ->
Thanks and a Question, Nick Leaton	Thread	Re: Thanks and a Question, Nick Leaton
Thanks and a Question, Nick Leaton	Date	Re: Thanks and a Question, Nick Leaton
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >