Re: Y2K problem on Standard Engine

What version are you running and what is DBDATE set to?? It looks like 290200 is expanding to 29021900 and then the engine is right Carlos wrote: > > We've got a problem with dates in SQL. > The next query results in -1204 error (invalid year in date). > > select ..... where date_field = "290200" > > In the other hand these querys work fine : > > select ...... where date_field = "280200" > > select ...... where date_field = "290204" > > Does anyone have any idea? > > Thanks in advance -- Paul Watson # WF Software # If it was easy Tel ++44 1436 674729 # Everybody could do it Fax ++44 1436 678693 # www.wfsoftware.com/informix #