[oXygen-user] date time format when importing from Excel

[Sorin Ristache]

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