Re: Year 2000 rollover for date fields
Posted in 1996
Paul, As of yet, you can't enter year 2000 dates with only two digits. Current Informix products always assume that 1900 should be added to two digit years. But, don't blame Informix for our lack of foresight. Two digit years were probably a bad idea all along. But, coming in the new product releases (7.12? 7.20?) there will be a new environment variable DBCENTURY. It will instruct Informix how to handle two digit years. It has values which mean always assume next century, assume closest century, etc. For now though, I don't know of any automated relief. On Wed, 20 Mar 1996 20:31:39 GMT, you wrote: >Does anyone know how to enter a 2000+ year on a 4GL perform screen >when a 2 digit year format is used? The date fields that use a 2 >digit year(MM/DD/YY) format will not allow you to enter a 2000+ year >entry. The year will be 1900 if you enter 01/01/00 on a date field. >You can enter a 4 digit year with a MM/DD/YYYY format. ====================================================================== Craig Kickel | Unix/C/Database Consultant ckickel@cyberhighway.net | <This space intentionally left blank> ======================================================================