This is a tricky one.

The element value being returned by the XML is '14 Mar 2007'

I want this to be displayed as : 14Mar07

I am using this :

<xsl:value-of select="DateVAlue"/>
which returns '14 Mar 2007.

How can I display this by as 14Mar07.

Do I need to use substring thrice?

In XSLT 2.0 you can do this with regular expressions and replace(). In 1.0 the simplest is probably to use substring thrice as you suggest.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference