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
>