Hi

I am trying to add 5 years to three nodes but it takes the first node date and it applies it to the following two nodes. Help would be appreciated.
Here is my xslt.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">


<xsl:variable name="maturDate1" select="/MxML/securities/security/financialDefinition/bondDefinition/streams/stream/maturity"/>

<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="node()|@*"/>
</xsl:copy>
</xsl:template>


<xsl:template match="/MxML/securities/security/financialDefinition/bondDefinition/streams/stream/maturity">


<xsl:variable name="maturYear" select="number(substring($maturDate1,1,4))+5"/>
<maturity>
<xsl:value-of select="concat($maturYear,substring($maturDate1,5, 4))"/>
</maturity>

</xsl:template>


</xsl:stylesheet>



INPUT XML

<MxML>
<securities>
<security>
<financialDefinition>
<bondDefinition>
<streams>
<structure>
<numberOfPhases>3</numberOfPhases>
<numberOfLegs>1</numberOfLegs>
</structure>
<stream>
<streamTemplate>
<phase>1</phase>
<leg>1</leg>
<paymentCurrency>JPY</paymentCurrency>
</streamTemplate>
<maturity>20101007 </maturity>
</stream>
<stream>
<streamTemplate>
<phase>2</phase>
<leg>1</leg>
<paymentCurrency>JPY</paymentCurrency>
</streamTemplate>
<maturity>20110414</maturity>
</stream>
<stream>
<streamTemplate>
<phase>3</phase>
<leg>1</leg>
<paymentCurrency>JPY</paymentCurrency>
</streamTemplate>
<maturity>20110414</maturity>
</stream>
</streams>
</bondDefinition>
</financialDefinition>
</security>
</securities>
</MxML>

OUTPUT

phase 2 and 3 dates are incorrect

<MxML>
<securities>
<security>
<financialDefinition>
<bondDefinition>
<streams>
<structure>
<numberOfPhases>3</numberOfPhases>
<numberOfLegs>1</numberOfLegs>
</structure>
<stream>
<streamTemplate>
<phase>1</phase>
<leg>1</leg>
<paymentCurrency>JPY</paymentCurrency>
</streamTemplate>
<maturity>20151007</maturity>
</stream>
<stream>
<streamTemplate>
<phase>2</phase>
<leg>1</leg>
<paymentCurrency>JPY</paymentCurrency>
</streamTemplate>
<maturity>20151007</maturity>
</stream>
<stream>
<streamTemplate>
<phase>3</phase>
<leg>1</leg>
<paymentCurrency>JPY</paymentCurrency>
</streamTemplate>
<maturity>20151007</maturity>
</stream>
</streams>
</bondDefinition>
</financialDefinition>
</security>
</securities>
</MxML>

Your variable $maturDate1 is a node-set containing 5 element nodes.

In XSLT 1.0, when you apply the substring() function to a set of 5 nodes, it operates on the first of those nodes (2.0 would give you a type error instead).

I think you simply want:

The global variable isn't useful.

Note, your date arithmetic is capable of generating an invalid date like 20090229. Using the date/time arithmetic provided in XSLT 2.0 would be more sound.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Thank you Michael.

I have to use xslt 1.0. and my real problem that I need to update every date independently in the node-set, I have tried what you suggested to match on the maturity date. I still get the node-set and can not correctly update teh dates in each node. is there away to preserve the xml structure and add 5 years to each date in the node.

I made the global variable a local variable in the template as you suggested.

Thank you
Boris

>I made the global variable a local variable in the template as you suggested.

I suggested nothing of the kind. It looks as if you didn't understand my code and changed it. Please show me the code you have now written and that still isn't working. Then perhaps I can see where your mental block is. Unfortunately writing code for people is often not a good way to solve their misunderstandings of the language.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Thank you very much Michael, when you said mental block, I immediately recognized what I did wrong.


Boris