• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

can i change dateformat in XSL

I have an XSL stylesheet which gets its data from an XML document.

One of the fields to be displayed is a date field. The xml data has the date in format dd-mm-yyyy. Can I do anything so that the XSL changes this format to dd-MMM-yy ?

So 01-01-2001 should display as 01-Jan-2001 !

Thanx!
Enkay
0
enkay022798
Asked:
enkay022798
  • 3
  • 2
1 Solution
 
djokovCommented:
In general, YES, but exactly how to do that depends on your xsl code. post it here to see what could be done.
it will be something like:

<xsl:template name="ChangeMonth">
<xsl:param name="Month"/>  <!-- here you will pass month 1-12 -->
<xsl:choose>
<xsl:when test="$Month = '1'">
<xsl:value-of select="Jan"/>
</xsl:when>
<xsl:when test="$Month = '2'">
<xsl:value-of select="Feb"/>
</xsl:when>
...
<xsl:when test="$Month = '12'">
<xsl:value-of select="Dec"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="Unrecognized Month!!!"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
0
 
enkay022798Author Commented:
I have been experimenting and yes, djokov, what you suggested will work fine.

Nevertheless, I was wondering if I could simplify this !

I tried to write a function which will do this using

<xsl:script><![CDATA[ tags. When I put this into my XSL, I get returned nothing !!! It doesnt matter wha I put in the function.

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"
version="1.0">

<xsl:script language="VBScript"><![CDATA[
function GetMeThis()
     GetMeThis = "date"
end function
]]>
</xsl:script>

<xsl:template match="/">
<xsl:eval>GetMeThis()</xsl:eval>
</xsl:template>
</xsl:stylesheet>

I have ripped off the other xsl tags as of now but no matter what ...
This gets me nothing !!!
0
 
enkay022798Author Commented:
djokov,

I want to leave this Q open for a lil more time. I would like to see some more suggestions, else I will use what you have suggested and award you the points.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
djokovCommented:
Yes, ok, but if it should be plain xslt, i don't think there is other way... however, let us see what other guys will offer.

cheers.
0
 
Wayne BradneyIndependent ConsultantCommented:
enkay,

If you're going to need to change the format in the future, or maybe have different formats for different people, you might consider using extensions (this is a string replace example, but you'll get the idea):

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                   xmlns:java="http://xml.apache.org/xslt/java"
                   exclude-result-prefixes="java"
               version="1.0">
    <xsl:output method="xml" indent="yes"/>
    <xsl:strip-space elements="*"/>
    <xsl:template match="/">
         <xsl:apply-templates/>
    </xsl:template>
    <xsl:template match="test[@att]">
         <xsl:variable name="str" select="@att"/>
         <xsl:variable name="find" select="_string_"/>
         <xsl:variable name="sub" select="_other_"/>
         <xsl:variable name="repl" select="java:Replacer.replace(string($str), string($find), string($sub))"/>
         <test>
              <xsl:attribute name="att"><xsl:value-of select="$repl"/></xsl:attribute>
         </test>
    </xsl:template>
</xsl:stylesheet>

And then you'd write a class Replacer with a method:

public static String replace(String, String, String)

that does whatever you like (in your case date formatting).

Regards,
WMB
0
 
enkay022798Author Commented:
Thank you everyone !
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now