XML File - Date field formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Bombay said:
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?
Click to expand...

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.
 
Back
Top