Re: [xsl] convert excel date to valid date format

[henry human <henry_human@xxxxxxxx>]

Hi

These is helpful and works ;)
Thanks
BR
henry





Wolfgang Laun
<wolfgang.laun@xxxxxxxxx> schrieb am 16:18 Freitag, 3.Januar 2014:
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@xxxxxxxx>
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@xxxxxxxxxxxxx</from>
> <subject>subject1</subject>
>
<received>41640.0</received>
> </record>
> <record>
>
<from>test@xxxxxxxxxxxxx</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@xxxxxxxxxxxxxxxxxxxxxx>
> --~--