Hello,

I'm brand new to XSL and I have a newbie question:

I'm trying to convert a value to a date. The format needs to be DD-MM-YYYY. I found this website that says I can use format-date(). But I get a compiler error: 'format-date()' is an unknown XSLT function. Obviously, I need to import some library that contains the format-date() function, but I don't know how to do that.

This is probably important too. The line I have that calls format-date() is:

<xsl:value-of select="format-date(PCR/VW_PI_PATIENTCONTACTS[@PERSONTYPEID=3]/@DOBDATE, 'DD-MM-YYYY')"/>

Can anyone help me please?

Thanks

You need to use an XSLT 2.0 or 3.0 processor like Saxon 9 or XmlPrime. The error you got suggests you use an XSLT 1.0 processor.

__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog

Martin is correct. But one other point, when you run this under an XSLT 2.0 processor, the picture string you need is not "DD-MM-YYYY" but "[D01]-[M01]-[Y0001]"

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

ok, thanks both.