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,154 of 9,834   
   Jim Hargan to Jeanette   
   Re: PLEASE HELP with CALC for MIN & MAX   
   12 Feb 07 20:03:43   
   
   From: noJimspam@omitThisHarganonline.com   
      
   On 12 Feb 2007 15:07:49 -0500, Jeanette wrote:   
      
   > 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)   
      
   IIUC, Paradox does *not* do anything special with dates. It just converts   
   them to integers, and performs normal integer arithmetic. It counts (I   
   think) 30 Dec 1899 as Day 0, then every succeeding day gets the next   
   integer. So, if you subtract:   
   3 Jan 1900 - 31 Dec 1899   
   Paradox converts this to   
   4 - 1 (the 4th day after 30 Dec 1899, minus the 1st day after)   
   and returns 3.   
      
   HTH   
      
   Jim Hargan   
      
   --- 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