[xsl] Re: date format

[Markus Spath <mspath@xxxxxxxx>]

stevenson wrote:

> I have a date coming from database in this form:  yyyy - mm - dd
> But i want to format it in my xsl document to become dd/mm/yy.
>
> How can i achieve this. 
>
> Can anyone assist me?
hello,

assumed you have got elements like <olddate>yyyy - mm - dd</olddate>

something like


 <xsl:template match="olddate">
   <date>
     <xsl:value-of select="substring(.,3,2)" />/<xsl:value-of select="substring(.,13,2)" />/<xsl:value-of select="substring(.,8,2)" />
   </date>
 </xsl:template>

should work.


substring(string, nr1, nr2) returns the substring of string, starting at nr1
with length nr2.

(Jeni probably provided a more elegant solution ;) )

-you might want to check out the xsl-list at mulberrytech.com, there the specialists hang out (if you don't mind the traffic).


cheers,
Markus



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