Create Runtime-SQL-Query with a date-criteria using ACCESS 97 as Frontend

Posted in 2000

Thomas Otto — Wed, 27 Sep 2000 14:45:13 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, i have a problem with creating a runtime-sql-query in access 97. access is the frontend and informix the backend. the query only works, if i use the datatype DATE and the us-english datesepartorsigns in systemcontrolpanal. but my operatingsytem is configured in german, so i have dots "." instead of slashes "/". the mistaken query is: dim ddate as date ddate = 27.09.2000 ...... WHERE field = ddate; the rifht query is: dim ddate as date ddate = 27/09/2000 ...... WHERE field = ddate; now my question: how can i solve this problem? many thanks in advance, Thomas Otto Mailto: OttoT@LSV-Gartenbau.de