home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,164 of 9,834   
   Jean Friedberg to Liz McGuire   
   Re: PLEASE HELP with CALC for MIN & MAX   
   13 Feb 07 11:22:16   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca