XSLT : DateTime Formatting?

sorry, i am quite confused. I need to include this stylesheet code in my existing xslt or save it in another xslt file? Can u please include a small example to implement this.

sherly,

> Can u please include a small example to implement this.

that is what you have in my post
It is a full working stylesheet that transforms this XML
<date>2001-11-13T13:32:28.0000000</date>
to 13 Nov 2001,13:32

In order to get it to work with your stylesheet
you need to include all of this in your existing stylesheet,
make sure you copy the attributes on the stylesheet element
and put the <map:dates> element after all the templates

you don't need to copy the date template
That one is just an example for you on how to call the named template

    <xsl:template match="date">
        <xsl:call-template name="dateTransformer">
            <xsl:with-param name="myDate" select="."/>
        </xsl:call-template>
    </xsl:template>

can be dropped

at the point where you have the date in  your source format,
you have to call the named template
like this
        <xsl:call-template name="dateTransformer">
            <xsl:with-param name="myDate" select="$thisDate"/>
        </xsl:call-template>
with instead of variable $thisDate you pass the date that needs converting

cheers

Geert

try this too...

-----------------------
    <xsl:template name="DateFormatter">
      <xsl:param name="WholeDate" />
      <xsl:variable name="YrMonDat" select="substring-before($WholeDate,'T')" />
      <xsl:variable name="TimeGiven" select="substring-after($WholeDate,'T')" />      
      <!--Extracting Date-->
      <xsl:variable name="Year" select="substring-before($YrMonDat,'-')" />
      <xsl:variable name="RemYear" select="substring-after($YrMonDat,'-')" />
      <xsl:variable name="Month" select="substring-before($RemYear,'-')" />
      <xsl:variable name="Day" select="substring-after($RemYear,'-')" />
      <xsl:variable name="MonthName">
        <xsl:choose>
          <xsl:when test="$Month = 1">Jan</xsl:when>
          <xsl:when test="$Month = 2">Feb</xsl:when>
          <xsl:when test="$Month = 3">Mar</xsl:when>
          <xsl:when test="$Month = 4">Apr</xsl:when>
          <xsl:when test="$Month = 5">May</xsl:when>
          <xsl:when test="$Month = 6">Jun</xsl:when>
          <xsl:when test="$Month = 7">Jul</xsl:when>
          <xsl:when test="$Month = 8">Aug</xsl:when>
          <xsl:when test="$Month = 9">Sep</xsl:when>
          <xsl:when test="$Month = 10">Oct</xsl:when>
          <xsl:when test="$Month = 11">Nov</xsl:when>
          <xsl:when test="$Month = 12">Dec</xsl:when>
          <xsl:otherwise>0</xsl:otherwise>
        </xsl:choose>
      </xsl:variable>

      <!--Extracting Time-->  
      <xsl:variable name="Hrs" select="substring-before($TimeGiven,':')" />    
      <xsl:variable name="RemHrs" select="substring-after($TimeGiven,':')" />
      <xsl:variable name="Min" select="substring-before($RemHrs,':')" />    
     
      <!-- Printing the Value -->      
      <xsl:value-of select="$Day" />&#160;<xsl:value-of select="$MonthName"/>&#160;<xsl:value-of select="$Year" />,&#160;<xsl:value-of select="$Hrs" />:<xsl:value-of select="$Min" />
    </xsl:template>
----------------------------------------

Regards - G.

gcmachel,

mmh, I don't see what value your answer adds...

The only real difference between the answer posted a while ago and your input
is that you replaced a lookup table with 12 when tests
I consider a lookup table far superior over a bunch of when tests
(the "when" testing will be a lot slower in december,
and the lookup table seperates real XSLT programming from changing a simple XML lookup,
when a change is needed at some point)

Is there a reason why you prefer this list of when statements?

cheers

Geert