Re: Selection based on date comparison
You don't say but I assume that you have the somewhat confusing mm/dd/yyy order. If instead you used the ISO format 1999-04-15 then you could just use xsl:sort and lexicographic sorting, or translate(@Trade_Date,'/','') and numeric sorting. Also you'd be able to declare that attribute as a date with W3C XML schema, should you ever wish to. As is you want to compare the resuts of concat(substring(@Trade_Date,7),substring(@Trade_Date,1,2),substring(@Trade_Date,4,2)) (ie numbers/strings of the form 19990405) David _____________________________________________________________________ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call Star Internet for details on the Virus Scanning Service. XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
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