Filtering problem

Hi All,
            I?m stumped by an XSLT problem. I have a series of elements
(shown below). I?m trying to building a report that groups these by status
type. I have three states ?submit?, ?approved? and ?complete?. Each coming
one after the other respectively. I need to filter these into something
similar to the bottom XML layout. Basically if an item has been ?approved?
it shouldn?t appear in ?submit? etc. This is easy enough, but I have to put
date restrictions on it. So if an item was ?approved?, but it was after
$endDate then it should be included in ?submit? or if an item is ?complete?
but after the endDate, but it was ?approved? during the date range then
include it in ?approved? but not ?submit?

Hope this makes sense

Input:
<item>
   <statusHistory>          
      <status>
         <type>
         <date>
      </status>
      ?
   </statusHistory>
   <itemDetails>
      ?
   </itemDetails>
</item>

Desired Output:
<summary>
   <complete>
      <itemDetails/>
   </complete>
   <approved>
      <itemDetails/>
   </approved>
   <submit>
      <itemDetails/>
   </submit>
</summary>

Thanks

Ryan Puddephatt



--~------------------------------------------------------------------
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(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--