Thank you all. This group is great!


Dimitre Novatchev wrote:
> http://www.topxml.com/code/default.asp?p=3&id=v20021212030100
>
> Cheers,
> Dimitre Novatchev
>
>
> "Anuradha RG" <anuradharg@g...> wrote in message
> news:1157532037.003196.250600@d......
> > 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
> >