>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

>Thread Prev - Re: XSL sort for DateTime data
>Thread Next - Re: XSL sort for DateTime data

Re: XSL sort for DateTime data

From: "Anuradha RG" <anuradharg@-----.--->
To: NULL
Date: 9/6/2006 1:41:00 AM


Thank you, but the datetime column that I use contains data of this
format:
"dd Mmm yyyy hh:mm"

So, the sorted output should be something like:
01 Jan 2006 01:10
05 Feb 2006 01:30
07 May 2006 10:20
07 Oct 2006 08:45

and so on. How to deal with this?


Joe Fawcett wrote:

> "Anuradha RG" <anuradharg@g...> wrote in message
> news:1157529917.456735.55310@d......
> > Iam using XSL sort in this fashion:
> >
> > <xsl:for-each select="ITEMS/ITEM">
> > <xsl:sort select="*[name() = $SortCol]" order="{$SortOrd}"
> > data-type="{$SortType}"/>
> >
> > When $SortCol refers to a column that contains Datetime data, it does
> > not sort, since the data-type attribute supports only "text" and
> > "number" types.
> >
> > Is there a workaround for this? Please help.
> >
> Yes, remove all non-numeric characters using translate and then sort by
> number.
> -- 
> 
> Joe Fawcett (MVP - XML)
> 
> http://joe.fawcett.name

>Thread Prev - Re: XSL sort for DateTime data
>Thread Next - Re: XSL sort for DateTime data

>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

Altova Mailing List Archives

Re: XSL sort for DateTime data