Subject: RE: [xsl] sort by date From: "Shenan Hawkins" <shenan@xxxxxx> Date: Tue, 26 Nov 2002 12:27:11 -0500 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] sort by date, Greg Faron | Thread | RE: [xsl] sort by date, Aniceto Lopez |
RE: [xsl] XML To RTF or MS DOC or , Astor Rivera | Date | RE: [xsl] sort by date, Ben Robb |
Month |