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,152 of 9,834   
   Liz McGuire to Jeanette   
   Re: PLEASE HELP with CALC for MIN & MAX   
   12 Feb 07 17:40:08   
   
   From: liz@paradoxcommunity.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