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,155 of 9,834   
   Liz McGuire to Jim Hargan   
   Re: PLEASE HELP with CALC for MIN & MAX   
   12 Feb 07 18:09:05   
   
   From: liz@paradoxcommunity.com   
      
   Actually, 01 Jan 0000 is day 0, or maybe day 1, I'm not sure.  Rick's   
   articles would probably answer this.   
      
   Liz   
      
      
   Jim Hargan wrote:   
   >   
   > 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