YEAR 2000 COMPLIANCE

This is a multi-part message in MIME format. ------=_NextPart_000_000C_01BE9ADA.E9559280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am working in a project for Year 2000 compliance and I was asked to = force the users to enter a 4 digit year using Informix 4gl software. I = am using 'format' and 'picture' but I have not been able to do it. Is = there a way to do it? How can it be done? I would appreciate any advise. Thank you, Ivan A. Ramirez (10700) ------=_NextPart_000_000C_01BE9ADA.E9559280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#d8d0c8> <DIV>I am working in a project for Year 2000 compliance and I was asked = to force=20 the users to enter a 4 digit year using Informix 4gl software.&nbsp; I = am using=20 'format' and 'picture' but I have not been able to do it.&nbsp; Is there = a way=20 to do it?&nbsp; How can it be done?</FONT><BR><FONT = size=3D3><BR></FONT><FONT=20 size=3D2>I would appreciate any advise.</FONT><BR><FONT = size=3D3><BR></FONT><FONT=20 size=3D2>Thank you,</FONT><BR><FONT size=3D2>Ivan A. Ramirez=20 (10700)</FONT><BR></DIV></BODY></HTML> ------=_NextPart_000_000C_01BE9ADA.E9559280--

T.A.P.S. wrote: > I am working in a project for Year 2000 compliance and I was asked > to force the users to enter a 4 digit year using Informix 4gl > software. I am using 'format' and 'picture' but I have not been > able to do it. Is there a way to do it? How can it be done? Succinctly, for most purposes, the answer is no. If you are really desparate, use PICTURE="####-##-##" and FORMAT = "YYYY-MM-DD" and enforce DBDATE=Y4MD-. Now the user cannot get to the MM and DD part without typeing 4 digits in the year. Probably, you don't want to force the users to type 4 digits for the year. You only want the program to display what the user entered with 4 digits for the year, and with sufficient check constraints on the specific columns to validate that the value is plausible if they entered 2 digits for the year and I4GL supplied the century. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>