Subject: RE: [xsl] date sorting with internationalisation From: "Kerry, Richard" <richard.kerry@xxxxxxxxxxx> Date: Thu, 17 Dec 2009 12:54:05 +0100 |
Convert the date, whatever format it starts in, into YYYYMMDDHHMMSS. (MM (month) being numeric) Then you can just use text sort on it. Not needing to worry about punctuation, or splitting into separate parts. Regards, Richard. > -----Original Message----- > From: Anil Kumar Veeramalli [mailto:anil.v@xxxxxxxxxxxxxxxxxxxxx] > Sent: 17 December 2009 09:56 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: [xsl] date sorting with internationalisation > > Hi , > > I am using XSL1.0 version. currently I am sorting the date > elements like > this. > my current date format is dd-MMM-yyyy HH:mm:ss. > <xsl:sort > select="substring-after(substring-after(substring(COLUMN[@NAME > ='N_DT_EFF'],1,12),'-'),'-')" > data-type="number"/> > <xsl:sort > select="string-length(substring-before($vMonthNames,substring- > before(substring-after(substring(COLUMN[@NAME='N_DT_EFF'],1,12 > ),'-'),'-')))" > data-type="number"/> > <xsl:sort > select="substring-before(substring(COLUMN[@NAME='N_DT_EFF'],1, > 12),'-')" > data-type="number"/> > > Now I want to support the same with French Language. in > French my date > format is looking like this 01-janv.-1900. > > what is the better way to sort French Dates. > > Thanks, > Anil
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] date sorting with internation, Anil Kumar Veeramall | Thread | [xsl] tokense or substring, Anil Kumar Veeramall |
RE: [xsl] tokense or substring, Michael Kay | Date | [xsl] strange issue with execution , Robby Pelssers |
Month |