Forcing date format in XML export

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

Hi

I am exporting my data to XML and I need to format the
date at YYYY/MM/DD. I know you can select this option
when exporting to .TXT yet for XML there is no option. I
have tried using the input mask to force the correct
format yet this only works for data entry and the date
always reverts back to dd/mm/yyyy.

Where am I going wrong? How do you force the date format
within access to be YYYY/MM/DD?
 
Not sure.
Can you write a query and format it that way and then export the query?
 
Back
Top