[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Sorting date format
>>Michael Kay >It's best to avoid date formats such as d/m/y or m/d/y - better to use the >ISO date format yyyy-mm-dd. This is supported directly in XSLT 2.0 via the >data type xs:date. If you're stuck with XSLT 1.0 and/or d/m/y format dates, >you will have to rearrange them into y/m/d format using a combination of >concat() and substring() operations, you can then convert 21/02/05 to >20050221, which you can then sort directly either as a number or as a >string. So it's something like ><xsl:sort select="concat(substring(.,7,2), substring(.,4,2), >substring(.,1,2)"/> I got the expected. Very nice explanation, Thanks a lot Mr. Michael. Regards, Ramkumar
|
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
|