This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: Selection based on date comparison
- From: David Carlisle <davidc at nag dot co dot uk>
- To: xsl-list at lists dot mulberrytech dot com
- Date: Fri, 30 Nov 2001 18:39:23 GMT
- Subject: Re: [xsl] Selection based on date comparison
- References: <F29EB4HGXAwxXSXI3ac00001819@hotmail.com>
- Reply-to: xsl-list at lists dot mulberrytech dot com
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