Re: datetime - datetime = interval but it is always null

Yes. If you don't use a multiple of 12 as the number of months (60 obviously is a multiple), you are likely to hit err 1267 (the result of a datetime computation isout of range) where s_date approaches the end of the month. Better use days or years instead. HTH, Marco Ah. After a month, I forgot what the original post was about (OK, OK, I probably deleted it without even reading it first :-), so I just don't know what the original poster was asking. ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On Mon, 13 Jan 97 08:10:35 GMT Rudy Fernandes <rferdy@kuwait.net> wrote: Here's a different approach. (The following code works on 4.1) IF s_date + 60 UNITS MONTH > e_date THEN discard... ELSE place in bin... END IF Or have I missed something in the problem? >}From: Kirk Waterhouse <kirk.waterhouse@usat.mhs.ciba.com> >}Date: Wed, 18 Dec 1996 16:32:59 -0800 >}X-Informix-List-Id: <news.31813> >} >}I am trying to compare the expiration date of a unit of inventory with >}the location I would like to put it in. If there is more than 60 months >}difference I want to put it somewhere else. ---------------------- Rudy Fernandes GIC, Kuwait ---------------------- -----------------End of Original Message-----------------