Re: About year 2000 rollover

On Apr 22, 4:44pm, Joel Schumacher wrote: > Subject: 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") You would prefer to get a new version of the software, add in this code, recompile, re-test and re-release your application. When you could just change the .per files of your current application to have 4 digit years? I somehow doubt it. In any case any screen that had such a combination of types on it would never really work in practice. The users would be confused about which century they would be looking at and they would be almost bound to request 4 digit years on the screen. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!