[2005 Exp] DataSet.WriteXML - Date Format

[Bruce Fox]

Hi Guys,

I have a DataSet(Table) that amongst other things has a 'date' field.

I currently have an 'Export to XML' feature that writes the data out using DataSet.WriteXML(somwhere),
and I have a corresponding XSL file that formats the data for the Browser.

All is good, except the 'Date' data is displayed in the following format: 2005-04-07T00:00:00+10:00.
I would like the format to be like: 2005-04-07 (or better yet, 07 Apr 2005).

I am aware the I may be able to use XSLT file and use some inbuilt functions, however, those posts I found are circa 2003.
I was wondering if there is a better (.Net 2005) way.



Cheers 'n' Beers.