Re: About year 2000 rollover

> I don't understand why Informix Co. don't solve about 2000+ year entry > with "MM/DD/YY" FORMAT. > > I work in a software company and have a lot of 4GL programes and if we > change the format to "MM/DD/YYY" can be very hard and a inconvenience > entry for our customers. > > What about $DBCENTURY ?. > > We've got SE engines Releases S.XX; What release will solve this > problem. ? > > We ended up solving this problem ourselves by creating a year_2000() function in 4GL which takes a dd/mm/yy date. If the yy < 96 it returns mm/dd/20YY, otherwise it returns mm/dd/19YY. This function is called in the after field clause of every date field throughout our applications screens. Painful initially, but it works. David N. Heydon LANGDON SYSTEMS LTD