Hello Robert, The format of the date in the result of the import operation is the format used by java.util.Date.toString(): dow mon dd hh:mm:ss zzz yyyy (day-of-week month day-of-month hour:minute:second timezone year) If you need an ISO 8601 format I think you can ignore the first token (dow) and rearrange the rest of the tokens. Also you need a mapping from the java.util.Date style of the timezone (GMT, PST, etc) to the ISO 8601 one (-01:00, -10:00, etc). In a future version we will allow the configuration of the date format. Regards, Sorin http://www.oxygenxml.com Robert Walpole wrote:
Thanks Sorin. Are you able to tell me what this format is that oXygen uses? Maybe then I can write some function to convert it.
Regards Rob
-----Original Message----- From: oxygen-user-bounces@oxygenxml.com [mailto:oxygen-user-bounces@oxygenxml.com] On Behalf Of Sorin Ristache Sent: 27 November 2006 09:16 To: oxygen-user@oxygenxml.com Subject: Re: [oXygen-user] date time format when importing from Excel
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
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