Assuming that @LastActionDate = 17-05-02
to convert it to YYYYMMDD use


20<xsl:value-of select="substring(@LastActionDate,8,2)"/><xsl:value-of
select="substring(@LastActionDate,4,2)"/>
<xsl:value-of select="substring(@LastActionDate,1,2)"/>

But if it's 17-MAY-02 you will have to assign the month MAY a variable which
assigns it to be 05.

-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of
AXRAMAKR@xxxxxx
Sent: 30 May 2002 15:40
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Cc: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx;
xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Date format



I have a date 17-MAY-02 from the oracle database that I would like to
format as YYYYMMDDHR24MI and another date 117-MAY-02 to be converted to
YYYYMMDD.

I wish to do the transformation in the XSLT. Has anyone done this before
and if so how did you do it?

Thanks,

Akila


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



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