Forcing date format in XML export

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?
 
J

Joe Fallon

Not sure.
Can you write a query and format it that way and then export the query?
 

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

Similar Threads

Date Format Incorrect on Export 1
XML File - Date field formatting? 1
Forcing a date entry format of dd/mm/yyyy 1
Exporting using Oracle date format 1
Dates in Export Specification Inconsistent in results 1
convert date 1
Date format in query export. 4
How to enter a date in DD-MM-YYYY format 2

Top