Hi there,
I am having a problematic date format when I save a Recordset into xml format using the following code:

Set rsTitles = CreateObject("ADODB.Recordset")
rsTitles.Open "Select brand, date_of_sale from cars"
rsTitles.Save szFile, 1 'adPersistXML

The output xml file contains a "strange" date format since between the date and time exists a "T"

date_of_sale='2001-06-11T11:47:00'

Any ideas what might go wrong?!

Regards,
Theodore.

What is you SQL server dateformat?
You got to change you SQLserver dateformat I believe

Or this may help

Select brand, convert(varchar(25),date_of_sale,121) from cars

Cheers!


-Vijay G

Thanks Vijay,
I didn't try the "121" option, but it did the work!

Regards,
Theodore.