D4GL Date display problem

Posted in 2001

Colin McGrath — Thu, 18 Jan 2001 17:05:48 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

Dynamic-4GL problem: > We are experiencing a strange phenomenon wrt entering dates in the format > YYYY-MMN-DD ..that is > when we entered say 2001-JAN-18 in a "date" field, the system is saving as > 2020-JAN-18. If however, we enter the date in the format YYYYMMDD i.e. > 20010118, the correct date is echoed. This is happening in all [Dynamic-4gl] > programs > > Can you shed some light on this? > The format string in the form is: FORMAT="yyyy-mmm-dd", but the 2001 year (in the "2001-JAN-18" that the user enters) is being interpreted as "20" and getting converting to 2020! Our date field size is 11 so it shows all the year, thank goodness. The date is not getting messed up in classic-4GL, only Dyamic, and it doesn't matter what the DBDATE format is set to. This is happening on a DEC (not sure of the version of D4GL) and under AIX with vers 3.0 D4GL. DBCENTURY=C -- Colin