RE: sort by date

That looks like a date that was returned by SQL Server FOR XML clause(?)

I sometimes need to deal with those strings as well.

Here are some (MS) functions I use below (I'm sure there is a _much_
better way to do this, though):


        <msxsl:script language="VBScript" implements-prefix="user">
        <![CDATA[ 
                function getAge(in_dteDate)
                        getAge = replace(in_dteDate, "T", " ")
                        getAge = dateDiff("d", getAge, now)
                end function


                function getDate(Node)
                        getDate = replace(Node, "T", " ")
                        getDate = formatDateTime(getDate, 1)
                end function


                function getTime(Node)
                        getTime = replace(Node, "T", " ")
                        getTime = formatDateTime(getTime, 3)
                end function    
                
        ]]> 
        </msxsl:script>

And then, for example:

<xsl:value-of select="user:getAge(string(@date))" />



Shenan



-----Original Message-----
From: Aniceto Lopez [mailto:aniceto(_at_)overthenet(_dot_)tv] 
Sent: Tuesday, November 26, 2002 12:16 PM
To: xsl-list
Subject: [xsl] sort by date


Hi:
I'm trying to sort by date but the date format is
a little bit extrange:

<a4013-list>
  <a4013 date="1998-01-03T00:00:00">FRUTAS</a4013>
  <a4013 date="1999-12-03T00:00:00">FRUTAS</a4013>
  <a4013 date="1999-05-03T00:00:00">FRUTAS</a4013>
  <a4013 date="2001-12-03T00:00:00">FRUTAS</a4013>
  <a4013 date="2001-12-03T00:00:00">FRUTAS</a4013>
  <a4013 date="1999-07-03T00:00:00">FRUTAS</a4013>
  <a4013 date="1999-12-03T00:00:00">FRUTAS</a4013>
  <a4013 date="2002-12-03T00:00:00">FRUTAS</a4013>
  <a4013 date="2002-07-03T00:00:00">FRUTAS</a4013>
</a4013-list>

the "T00:00:00" has no use but some one can point an
idea to get the desired sort by date?

thanks in advance
Ani

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list