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

[Sorin Ristache]

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:  
>> [mailto:] On Behalf Of Sorin Ristache
>> Sent: 27 November 2006 09:16
>> To: 
>> 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