RE: [xsl] sort by date

["Shenan Hawkins" <shenan@xxxxxx>]

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@xxxxxxxxxxxxx] 
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