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(_dot_)v(_at_)frescoinformatics(_dot_)com]
Sent: 17 December 2009 09:56
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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[(_at_)NAME
='N_DT_EFF'],1,12),'-'),'-')"
data-type="number"/>
<xsl:sort
select="string-length(substring-before($vMonthNames,substring-
before(substring-after(substring(COLUMN[(_at_)NAME='N_DT_EFF'],1,12
),'-'),'-')))"
data-type="number"/>
<xsl:sort
select="substring-before(substring(COLUMN[(_at_)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
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--