[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] Comparing multiple dates to display the most recent


Subject: [xsl] Comparing multiple dates to display the most recent
From: "Katie McNally" <kmcnally9@xxxxxxxxxxx>
Date: Thu, 10 Jan 2002 13:46:06 -0600

For the XML included below, I would like to display one value for the Mortage date (RequestType = MORTGAGE).

For the example xml below I want to display:
Mortgage Request Date: 12/23/2001

Multiple Mortgage dates can be returned in the xml, but only the most recent should be displayed. If I don't know the number of dates returned (of type MORTGAGE) ahead of time, how do I determine which date is the most recent and then display it?

XML:

<Loan>
 <RequestSet>
   <Request>
 	<DateRequested>03-Dec-2001 16:55:23</DateRequested>
 	<RequestType>MORTGAGE</RequestType>
   </Request>
   <Request>
	 <DateRequested>06-Dec-2001 14:33:00</DateRequested>
 	<RequestType>FLOOD</RequestType>
   </Request>
   <Request>
	 <DateRequested>07-Dec-2001 11:38:00</DateRequested>
 	<RequestType>MORTGAGE</RequestType>
   </Request>
   <Request>
	 <DateRequested>23-Dec-2001 13:18:00</DateRequested>
 	<RequestType>MORTGAGE</RequestType>
   </Request>
   <Request>
	 <DateRequested>04-Dec-2001 12:31:00</DateRequested>
 	<RequestType>HAZARD</RequestType>
   </Request>
 </RequestSet>
</Loan>


_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list




Current Thread
Keywords
xml