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