Excel XML - Formating Dates

S

Stuart Shay

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

<DateStamp>2004-08-04T17:56:09.4330000-04:00</DateStamp>
<DateStamp>2004-08-05T15:59:17.6700000-04:00</DateStamp>
<DateStamp>2004-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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top