Excel XML - Formating Dates
Hello All:
I have created a ASP.NET Web Application that takes the contents of DataSet
XML and Transforms the XML into Excel XML.
Ver: Excel XP
In the XML the dates are in the following format
<DateStamp2004-08-04T17:56:09.4330000-04:00</DateStamp
<DateStamp2004-08-05T15:59:17.6700000-04:00</DateStamp
<DateStamp2004-08-05T15:58:30.0770000-04:00</DateStamp
In my XSLT I have something like this
<Cell ss:StyleID="s30"<Data ss:Type="String"<xsl:value-of
select="DateStamp"/</Data</Cell
If I define the Datatype as a DateTime a error occurs, I would like to
format the date such as
Aug 8, 2004 12:23 AM
Is there a way I can format the date col to my worksheet so it is more human
readable.
Thanks
Stuart
|