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