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,206 of 9,834   
   Rick Kelly to Liz McGuire   
   Re: PLEASE HELP with CALC for MIN & MAX   
   21 Feb 07 21:51:10   
   
   From: somebody@anybody.com   
      
   Jan 1, 1 is day 1.   
      
   Rick   
      
   "Liz McGuire"  wrote in message   
   news:45d10fb2$1@pnews.thedbcommunity.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