You can use this simple function:
<xsl:function name="wl:todate" as="xs:dateTime">
<xsl:param name="days" as="xs:double"/>
<xsl:value-of select="xs:dateTime('1900-01-01T00:00:00') +
xs:dayTimeDuration(concat('P',xs:integer($days),'D'))"/>
</xsl:function>
I'm not sure what the value returned by EXCEL actually means; if I run
41640.0 through this function, the result is 2014-01-03T00:00:00, but
this can be adjusted, of course.
-W
On 03/01/2014, henry human <henry_human(_at_)yahoo(_dot_)de> wrote:
Hi
This XML is created by export of an EXCEL spreadsheet.
(For the export of EXCEL data to XML I used the below the same XML structure
such as the the XML file below as a schema too to use the mapping
functionality of EXCEL as it is described by Microsoft tutorials)
In the field received in the original EXCEL file the value for both record
elements was January 01.01.2014 but after export it was automatically
converted to 41640.0
In Java I could convert the value with help of java.util.Calendar to the
original value.
Is it there a way converting the format in XSLT too?
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<record>
<from>test(_at_)info-test(_dot_)com</from>
<subject>subject1</subject>
<received>41640.0</received>
</record>
<record>
<from>test(_at_)info-test(_dot_)com</from>
<subject>subject2</subject>
<received>41640.0</received>
</record>
</data-set>
BR
henry
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--