Re: About year 2000 rollover

Jim gordon's comments have inspired me to hazard a little question. Has anybody ever tried setting DBDATE to dmy4 followed by a NULL. Would it work? Then all suers only need chage DBDATE. > 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! Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc