RE: [xsl] Sorting date format

Subject: RE: [xsl] Sorting date format
From: "V.Ramkumar" <v.ramkumar@xxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 23 Dec 2008 16:30:43 +0530
>>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

Current Thread