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,153 of 9,834   
   Liz McGuire to Rick Rans   
   Re: PLEASE HELP with CALC for MIN & MAX   
   12 Feb 07 17:42:14   
   
   From: liz@paradoxcommunity.com   
      
   That's true, Rick, but the date math is correct in all cases.  High date   
   minus low date is the numbers she shows and those numbers are correct   
   and consistent - all are NOT inclusive of the first day, which is basic   
   math.   
      
   Liz   
      
      
   Rick Rans wrote:   
   > Don't know if this helps but the first two cross month boundaries and the   
   > third one is in the same month.   
   >   
   >   
   > "Jeanette"  wrote in message   
   > news:45d0c915$1@pnews.thedbcommunity.com...   
   >> 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 !   
   >>   
      
   --- 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