Hello, No, you cannot change the import format of dates in the current version. I added a request to our database for allowing the specification of the format of dates imported from an Excel spreadsheet. Regards, Sorin http://www.oxygenxml.com Robert Walpole wrote:

Hi,

I am using oXygen's very useful import tool to convert some data in a spreadsheet to XML. In the spreadsheet there are several fields which contain a date/time. When I import these fields they come out in the format <date>Fri Dec 06 00:00:00 GMT 2002</date> no matter what format I use in the source document.

It seems to me that oXygen is correctly recognising that these are dates but then putting them into a format which I don't recognise. Really I want them to be ISO 8601 (YYYY-MM-DDThh:mm:ss.sss). I have tried defining this as a custom format in the spreadsheet but it is still coming out as shown when I run the import.

Is there some way I can specify the format I want in oXygen?

Thanks Rob Walpole