From: harrisjr@bwsc.org   
      
   You're OK, I undersood what you said, I BELIEVE.   
      
   Even though I know the ASSUME THEORY I ASSUMED the # would be the actual   
   # of days like 12/31/05-1/1/05 would be 365 and not 364.   
      
   I guess I am being too wordy.  Are there any SPECIFIC rules regarding the   
   arithmentic of Dates?  I'm looking for some rules about when a date range   
   will be INCLUSIVE.   
      
   It seems like:   
   a)  02/1/06-1/15/06 is INCLUSIVE (17)   
   b)  12/31/05-9/15/05 is INCLUSIVE (107)   
   BUT   
   c)  10/1/06-1/1/06 is NOT INCLUSIVE (9)   
      
   I don't understand why a&b are INCLUSIVE and c is NOT...   
      
   SORRY - maybe it's in my face and I just don't see it !   
      
   Liz McGuire  wrote:   
   >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)