From: jfriedberg@mycomcast.com   
      
   :-)   
      
   "Liz McGuire" wrote in message   
   news:45d108e9$1@pnews.thedbcommunity.com...   
   > Jeanette wrote:   
   > > 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 !   
   >   
   > Jeanette,   
   >   
   > If you include both the 15th and the 1st, a) is 18; b) if you include   
   > both the 15th and the 31st is 108; and c) seems to use a different date   
   > format (october 1 to january 1, 9 days, huh?) - or, it's january 10:   
   >   
   > 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 - ten days, inclusive.   
   >   
   > What you're doing is subtracting the low date from the high date and in   
   > all cases, the low date is excluded, just like when you subtract 1 from   
   > 10 the 1 is excluded. All of those behave the same way - all are NOT   
   > inclusive of the first day.   
   >   
   > Get a calendar - a printed one - manually count the first day in the   
   > range as 1 and each day up through the last day. If you include both   
   > the first and last days, you'll find that all of those numbers below   
   > exclude the start date.   
   >   
   > Or:   
   > a)   
   > 1 15 Jan 2006   
   > 2 16 Jan 2006   
   > 3 17 Jan 2006   
   > 4 18 Jan 2006   
   > 5 19 Jan 2006   
   > 6 20 Jan 2006   
   > 7 21 Jan 2006   
   > 8 22 Jan 2006   
   > 9 23 Jan 2006   
   > 10 24 Jan 2006   
   > 11 25 Jan 2006   
   > 12 26 Jan 2006   
   > 13 27 Jan 2006   
   > 14 28 Jan 2006   
   > 15 29 Jan 2006   
   > 16 30 Jan 2006   
   > 17 31 Jan 2006   
   > 18 01 Feb 2006   
   >   
   > b)   
   > 1 15 Sep 2005   
   > 2 16 Sep 2005   
   > 3 17 Sep 2005   
   > 4 18 Sep 2005   
   > 5 19 Sep 2005   
   > 6 20 Sep 2005   
   > 7 21 Sep 2005   
   > 8 22 Sep 2005   
   > 9 23 Sep 2005   
   > 10 24 Sep 2005   
   > 11 25 Sep 2005   
   > 12 26 Sep 2005   
   > 13 27 Sep 2005   
   > 14 28 Sep 2005   
   > 15 29 Sep 2005   
   > 16 30 Sep 2005   
   > 17 01 Oct 2005   
   > 18 02 Oct 2005   
   > 19 03 Oct 2005   
   > 20 04 Oct 2005   
   > 21 05 Oct 2005   
   > 22 06 Oct 2005   
   > 23 07 Oct 2005   
   > 24 08 Oct 2005   
   > 25 09 Oct 2005   
   > 26 10 Oct 2005   
   > 27 11 Oct 2005   
   > 28 12 Oct 2005   
   > 29 13 Oct 2005   
   > 30 14 Oct 2005   
   > 31 15 Oct 2005   
   > 32 16 Oct 2005   
   > 33 17 Oct 2005   
   > 34 18 Oct 2005   
   > 35 19 Oct 2005   
   > 36 20 Oct 2005   
   > 37 21 Oct 2005   
   > 38 22 Oct 2005   
   > 39 23 Oct 2005   
   > 40 24 Oct 2005   
   > 41 25 Oct 2005   
   > 42 26 Oct 2005   
   > 43 27 Oct 2005   
   > 44 28 Oct 2005   
   > 45 29 Oct 2005   
   > 46 30 Oct 2005   
   > 47 31 Oct 2005   
   > 48 01 Nov 2005   
   > 49 02 Nov 2005   
   > 50 03 Nov 2005   
   > 51 04 Nov 2005   
   > 52 05 Nov 2005   
   > 53 06 Nov 2005   
   > 54 07 Nov 2005   
   > 55 08 Nov 2005   
   > 56 09 Nov 2005   
   > 57 10 Nov 2005   
   > 58 11 Nov 2005   
   > 59 12 Nov 2005   
   > 60 13 Nov 2005   
   > 61 14 Nov 2005   
   > 62 15 Nov 2005   
   > 63 16 Nov 2005   
   > 64 17 Nov 2005   
   > 65 18 Nov 2005   
   > 66 19 Nov 2005   
   > 67 20 Nov 2005   
   > 68 21 Nov 2005   
   > 69 22 Nov 2005   
   > 70 23 Nov 2005   
   > 71 24 Nov 2005   
   > 72 25 Nov 2005   
   > 73 26 Nov 2005   
   > 74 27 Nov 2005   
   > 75 28 Nov 2005   
   > 76 29 Nov 2005   
   > 77 30 Nov 2005   
   > 78 01 Dec 2005   
   > 79 02 Dec 2005   
   > 80 03 Dec 2005   
   > 81 04 Dec 2005   
   > 82 05 Dec 2005   
   > 83 06 Dec 2005   
   > 84 07 Dec 2005   
   > 85 08 Dec 2005   
   > 86 09 Dec 2005   
   > 87 10 Dec 2005   
   > 88 11 Dec 2005   
   > 89 12 Dec 2005   
   > 90 13 Dec 2005   
   > 91 14 Dec 2005   
   > 92 15 Dec 2005   
   > 93 16 Dec 2005   
   > 94 17 Dec 2005   
   > 95 18 Dec 2005   
   > 96 19 Dec 2005   
   > 97 20 Dec 2005   
   > 98 21 Dec 2005   
   > 99 22 Dec 2005   
   > 100 23 Dec 2005   
   > 101 24 Dec 2005   
   > 102 25 Dec 2005   
   > 103 26 Dec 2005   
   > 104 27 Dec 2005   
   > 105 28 Dec 2005   
   > 106 29 Dec 2005   
   > 107 30 Dec 2005   
   > 108 31 Dec 2005   
   >   
   > c)   
   > 1 01 Jan 2006   
   > 2 02 Jan 2006   
   > 3 03 Jan 2006   
   > 4 04 Jan 2006   
   > 5 05 Jan 2006   
   > 6 06 Jan 2006   
   > 7 07 Jan 2006   
   > 8 08 Jan 2006   
   > 9 09 Jan 2006   
   > 10 10 Jan 2006   
   >   
   >   
   >   
   > Liz   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|