RE: Date format

Akila,

replace the line
                   <xsl:value-of select="substring($ADate,8,4)"/>
with

<xsl:text>20</xsl:text>
<xsl:value-of select="substring($ADate,8,2)"/>


Rgds
Ali


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



Ali,
Thanks for your help. However, when I call the template like this
<xsl:call-template name="ConvertRtDate">
                  <xsl:with-param name="ADate" select ="@trndte"/>
            </xsl:call-template>

The date of 17-MAY-02 gets converted to 020517. How do I make it 20020517?

Thanks,

Akila




                      "Ali Mutlu"
                      <alimutlu@xxxxxxxxxxxx>           To:
<xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
                      Sent by:                          cc:
                      owner-xsl-list@xxxxxxxxxxx        Subject:  RE: 
Date format
                      rrytech.com


                      05/30/02 08:15 AM
                      Please respond to xsl-list






>> 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?


Akila,

The following template translates anything like dd-mmm-yyyy to yyyymmdd, I
beleive a shorter way may exists, but it works

Rgds
Ali


<xsl:template name="ConvertRtDate">
             <xsl:param name="ADate"/>
                         <xsl:value-of select="substring($ADate,8,4)"/>
                         <xsl:choose>
                                     <xsl:when test="substring($ADate,4,3)
='JAN'">
                                                 <xsl:value-of select
="'01'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='FEB'">
                                                 <xsl:value-of select
="'02'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='MAR'">
                                                 <xsl:value-of select
="'03'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='APR'">
                                                 <xsl:value-of select
="'04'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='MAY'">
                                                 <xsl:value-of select
="'05'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='JUN'">
                                                 <xsl:value-of select
="'06'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='JUL'">
                                                 <xsl:value-of select
="'07'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='AUG'">
                                                 <xsl:value-of select
="'08'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='SEP'">
                                                 <xsl:value-of select
="'09'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='OCT'">
                                                 <xsl:value-of select
="'10'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='NOV'">
                                                 <xsl:value-of select
="'11'"/>
                                     </xsl:when>
                                     <xsl:when test="substring($ADate,4,3)
='DEC'">
                                                 <xsl:value-of select
="'12'"/>
                                     </xsl:when>
                         </xsl:choose>
             <xsl:value-of select="substring($ADate,1,2)"/>
</xsl:template>







 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