From: harrisjr@bwsc.org   
      
   I am creating a report that shows construction Cost projections.   
   Given the bgn & end dates Costs are shown via Month and Year.   
   For each street I calc the # of days between bgn & end and sum them to get   
   a grand total # of days (TNOD). The street cost is divided by TNOD for a   
   daily cost.   
      
   here's the hitch - in the example below:   
    2005 # = 107   
    2006 # = 90 for a TNOD of 197   
   if I were able to get the # of days via MAX(end) - MIN(bgn) I would have   
   a TNOD of 198 since the dates are consectuve months.   
      
   Can you help me code this occurence?   
      
   Year   StreetCODE  StreetCost     Begin       End   
   2005   06520       $282,208.40	  09/15/2005  12/31/2005	 	 	 	   
   2006   06520       $282,208.40	01/01/2006  04/01/2006   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)