DATEs

Dr. Richard Spitz (spitz@ana.med.uni-muenchen.de ) wrote: >ANOTHER PROBLEM with Q+E /I-NET: > >We cannot enter any DATEs into our Q+E forms. No matter how we enter them, >either Q+E or INFORMIX complain about a wrong format or invalid month. >That happens for dates where the "day" portion is > 12. Obviously, the day >is taken for the month and vice versa. Everything we tried didn't work. > >Any suggestions? Obviously the form expects American date formats (mm/dd/yy). I don't know if Q+E allows alternative formats but you can define INFORMIX date formats by setting the DBDATE environment variable thus: DBDATE=dmy2/ means dd/mm/yy format using "/" as the separator - the "2"means the year will be represented by the last two digits only. DBDATE=mdy4/ would expect dates of the form mm/dd/yyyy - I think thisis the default, so even if DBDATE is null this will be the case. BTW - what will happen in the year 2000? I'm using the two-digit year format - does this mean that 93 will be read as 2093 or 1993??? Just wondering.... Barry ** Opinions expressed are my own and not necessarily those of my employer ========================================================================= Barry Toomey Phone +353-1-2822333 AT&T Network Systems Ireland Fax +353-1-2822864 Corke Abbey Avenue, email: bt@irl3b2c.att.comm Bray, uunet: att!irl3b2c!bt Co. Dublin Ireland ========================================================================= '