From: liz@paradoxcommunity.com   
      
   I don't know how else to explain it.  198 excludes the start date from   
   the calculation. 90 and 107 exclude two start dates from the   
   calculation.  If you want to exclude the start date, I reckon you'll   
   have to:   
      
   a) use the min start and max end - gets you 198   
      
   OR   
      
   b) count how many rows there are for the given street, sum the two   
   ranges and add n-1, where n is the number of rows.   
      
   Or something.   
      
   Liz   
      
      
   Jeanette wrote:   
   > Helpful but...   
   > the idea is to get a daily cost and project it given the BGN & END dates   
   > and then the amounts should roll up to the original StreetCost.   
   >   
   > It's not happening if I use 199 days for the example below.   
   > HOWEVER if the BGN & END dates were not broken up by a RptYear the TNOD would   
   > be 198 and that allows an accurate rollup to the StreetCost BUT as (END-BGN).   
   >   
   > AND using dates 1/15/06 thru 2/1/06 and 9/15/05 thru 12/31/05 for 2 seperate   
   > streets (END-BGN)+1 does not allow an accurate rollup to the StreetCost -   
   > it does if (END-BGN)is used...   
   >   
   > WHAT TO DO ????   
   >   
   >   
   >   
   >   
   > "Liz McGuire"  wrote:   
   >> 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)