Re: VB, Informix and selecting by date woes

Posted in 2000

Sergey Turin — Fri, 4 Aug 2000 10:52:13 +0400 — source: Informix-list mailing list archive (1991-1998)

Rob Stevens <rob@teleflorist.co.uk> wrote in message news:39894b78_4@goliath.newsfeeds.com... > thanks for all your help so far... > ok, after much fiddling I've got the following line to work (notice I had to > reverse the date and enter it as YY/DD/MM): > > rs.Open "SELECT * From member WHERE l_date_joined = '49/01/01'", cn > > problem now is that as soon as I specify a four digit year (eg 1949 as I > would like to do above) I get a string to date conversion error from the > odbc driver! > > any ideas? Check date/time settings in Control panel and DBDATE variable setting in SETNET32. Set the former to YMD4/ ( "1949/01/01"). Hope this helps, Sergey