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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sorin Ristache
Sent: 27 November 2006 09:16
To: [email protected]
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
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
_______________________________________________
oXygen-user mailing list
[email protected]
http://www.oxygenxml.com/mailman/listinfo/oxygen-user
