Excel Import date format not easy to use

[suitts]

Hi,

I'm having some trouble using dates imported from Excel using oXygen 7.2, my date in Excel looks like this:

12/5/06 (US English cell formatted as Date)

When I use the Import from Excel feature in Oxygen I get this date:

<element>Tue Dec 05 00:00:00 PST 2006</element >

Which is correct except that I cannot easily parse it into ISO-8601 to use as an XML Schema date (section 3.2.9). http://www.w3.org/TR/xmlschema-2/#date The date appears to be in standard java.util.Date.toString() format.

Any suggestions? It would be great if oXygen created the date elements in a XML Schema friendly way without writing a complex XSLT.

Thanks!
~ Jason

[sorin_ristache]

Hello,

I added your request in our database. In a future version oXygen will import dates as in XML Schema: 2002-05-12T12:00:00-05:00.

Regards.
Sorin