Re: About year 2000 rollover

While the following looks like a step in the right direction, I think an environmental variable isn't flexible enough. I may have an employee setup screen with several fields. Birthdate (always in the past), next review date (always future) and other fields that "closest" logic applies to. It would be nice if Informix provided a call to customize the logic between fields in a form. ie. BEFORE FIELD birth_date CALL set_dbcentury("P") > ======================================================================== > > DBCENTURY -- 2-digit years and 2000 > > The environment variable DBCENTURY should be set to one of: > > C closest (generally most useful) > P past (closest previous year) > F future (closest future year) > R present (present century) > > With thanks to June Tong at Informix for this information > > ======================================================================== __________________________________________________________________________ Joel Schumacher JCPenney Co. - UNIX Network Systems jschumac@uns-dv1.jcpenney.com 12700 Park Central Pl (214) 591-7543 Dallas TX 75251