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

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 ----------------------