rutgermons
asked on
xsl function add days to a day
folks
anybody have an xsl that contains a function to add days to a date?
anybody have an xsl that contains a function to add days to a date?
ASKER
im looking for an xslt function not excel
If you use MSXML you can embed and call your own vbscript function.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
got it to work
<xsl:call-template xmlns:date="http://exslt.org/dates-and-times" name="date:add">
<xsl:with-param name="date-time" select="$var2_resultof_fir st" as="item()"/>
<xsl:with-param name="duration" select="xs:duration('-P3D' )" as="item()"/>
<xsl:call-template xmlns:date="http://exslt.org/dates-and-times" name="date:add">
<xsl:with-param name="date-time" select="$var2_resultof_fir
<xsl:with-param name="duration" select="xs:duration('-P3D'
If I have a cell (let's say A1) with "=TODAY()" it will show the current date.
If I have a cell with "=A1+1" it will show the current day plus 1 day, so now it shows 05/07/2014.
Is this what you're looking for?
Kind regards,
Ricardo Rebelo