Lasy day of the month

[Sudesna]

hi,

Could someone please tell me how to calculate the last day of the month, from the month number given, for example: 9, 10? ie find the last day of sept. or oct. , using xslt 2.0?

Thanks
.

[jkmyoung]

say value is in $month
<xsl:value-of select="document('')//month[@number=$month]/@last"/>

<my:mapping xmlns:my="internal">
<month number="1" last="31"/>
<month number="2" last="28"/>
<month number="3" last="31"/>
<month number="4" last="30"/>
<month number="5" last="31"/>
<month number="6" last="30"/>
<month number="7" last="31"/>
<month number="8" last="31"/>
<month number="9" last="30"/>
<month number="10" last="31"/>
<month number="11" last="30"/>
<month number="12" last="31"/>
</my:mapping>

[Sudesna]

say value is in $month
<xsl:value-of select="document('')//month[@number=$month]/@last"/>

<my:mapping xmlns:my="internal">
<month number="1" last="31"/>
<month number="2" last="28"/>
<month number="3" last="31"/>
<month number="4" last="30"/>
<month number="5" last="31"/>
<month number="6" last="30"/>
<month number="7" last="31"/>
<month number="8" last="31"/>
<month number="9" last="30"/>
<month number="10" last="31"/>
<month number="11" last="30"/>
<month number="12" last="31"/>
</my:mapping>

hi, this does not work, because I have to show the whole date, i.e. 31.09.2008.
And will this code work in xslt 2.0?

thanks

[jkmyoung]

Then put <xsl:value-of>'s to show your month and year.
XSLT 2.0 is backwards compatible to 1.0, except for very few exceptions which no one uses anyways.

[virgiloz]

This code works fine for 3 out of 4 years ... but what about leap years? Every fourth year February has 29 days. But wait ... that is except every 100th year ... when it doesn't! Ie: generally, there are 24 leap years every 100 years. But wait ... again ... that is, except for every 400th year! Which is a leap year .... so you have 24 leap years every 100 years for 300 years and then 25 leap years for the next 100 years. Totally confused? I thought so! Here's a piece of generic code that explain it!

if year modulo 400 is 0 then leap
else if year modulo 100 is 0 then no_leap
else if year modulo 4 is 0 then leap
else no_leap
endif

Someone might like to bash that into XML and paste it back in this thread.

Cheers

virgil.