Date format in XML export

[vjohnson]

Hello Everyone,

I need to know is there a way to format the date going from a access
table export to xml so that instead of <DOB>1961-08-07T00:00:00</DOB>
in the xml file I get <DOB>1961-08-07</DOB> in the xml file. In access
the field is all ready formated as a date/time, and short date.

Thank you so much for your help....

 

[John Vinson]

Hello Everyone,

I need to know is there a way to format the date going from a access
table export to xml so that instead of <DOB>1961-08-07T00:00:00</DOB>
in the xml file I get <DOB>1961-08-07</DOB> in the xml file. In access
the field is all ready formated as a date/time, and short date.

Thank you so much for your help....

Any Export will ignore the format setting of the field. What you can
do instead is use a calculated field using the Format() function to
explicitly recast the date into a text string:

ExpDate: Format([datefield], "yyyy-mm-dd")


John W. Vinson[MVP]