From: liz@paradoxcommunity.com   
      
   Jeanette,   
      
   1 through 10, inclusive, includes a total of 10 numbers.   
      
   10 - 1 = 9   
      
   1 is subtracted, so there's only 9 numbers left.   
      
   The first date range (2005) has 108 days, inclusive.  The second has 91 days   
   (inclusive).  Together, there are 199 days (inclusive).   
      
   However, when you're doing date math, "EndDate - StartDate" **subtracts the   
   start date**.  In other words, the StartDate is not being included in the   
   count of days.  If you want to be inclusive, do:   
      
   (EndDate-StartDate)+1   
      
   ...then you'll get 108 days in 2005, 91 days in 2006 and 199 days total.   
      
   HTH,   
      
   Liz   
      
      
   "Jeanette"  wrote:   
   >   
   >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)