Could someone please advise on how to accomplish this task?
XML:
<Promotions>
    <Promotion Code="test" Hits="1">
        <Sale Date="6/5/2005" Amount="114.75" OrderID="31"/>
        <Sale Date="5/5/2005" Amount="60.70" OrderID="29"/>
        <Sale Date="7/5/2004" Amount="500.75" OrderID="28"/>
        <Sale Date="6/1/2005" Amount="110.00" OrderID="30"/>
        <Sale Date="6/1/2004" Amount="40.00" OrderID="32"/>
    </Promotion>
<Promotion Code="test2" Hits="15">
        <Sale Date="4/5/2005" Amount="114.75" OrderID="31"/>
        <Sale Date="1/5/2005" Amount="71.70" OrderID="29"/>
        <Sale Date="7/6/2004" Amount="45.75" OrderID="28"/>
        <Sale Date="3/1/2005" Amount="10.00" OrderID="30"/>
        <Sale Date="10/1/2004" Amount="40.00" OrderID="32"/>
    </Promotion>

</Promotions>

I need to group by month and calculate monthly totals for each code.
Any advice would be greatly appreciated!

Please, someone respond....

First, I don't know whether your dates are in d/m/y format or m/d/y format. Choosing 10 sample dates that are all ambiguous requires skill!

Secondly, you'd be much better off using the standard ISO 8601 format yyyy-mm-dd.

You've got two problems here: parsing the dates, and then grouping by common values. For the parsing problem, you need a combination of substring-after() and substring-before(). For the grouping problem, assuming you're using XSLT 1.0, see the notes on grouping at http://www.jenitennison.com/xslt/grouping



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

I think michael is right, for example u can look into this url to get the idea how to do it. http://www.biglist.com/lists/xsl-lis.../msg00200.html


Thanks &amp; Regards
Naveen.