RE: [xsl] sort by date

Subject: RE: [xsl] sort by date
From: "Aniceto Lopez" <aniceto@xxxxxxxxxxxxx>
Date: Tue, 26 Nov 2002 18:46:58 +0100
Thanks Shenan but:
the clause is AUTO
where this script should be placed?
the xslt is java one, not Microsoft
does it help?

Ani



-----Mensaje original-----
De: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]En nombre de Shenan
Hawkins
Enviado el: martes, 26 de noviembre de 2002 18:27
Para: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Asunto: RE: [xsl] 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@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




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


Current Thread