XML File - Date field formatting?

[Guest]

I have a date field in my database that is formatted for MM/DD/YYYY and when
it is exported to an xml file, it shows up as the following
2007-11-21T00:00:00

So it is being exported YYYY-MM-DDTHH:MM:SS

Any idea how to force the export of that data as MM/DD/YYYY?

 

[Rick Brandt]

I have a date field in my database that is formatted for MM/DD/YYYY
and when it is exported to an xml file, it shows up as the following
2007-11-21T00:00:00

So it is being exported YYYY-MM-DDTHH:MM:SS

Any idea how to force the export of that data as MM/DD/YYYY?

Export a query instead of your table and use the Format() function (not the
format property) to force the format you want in the query's output.