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