I have an application that imports data from a Timberline database via
Timberline's own ODBC driver. The application is written in C# and
uses the MS ODBC.Net provider to connect to a Timberline database via a
DSN set up with the Timberline ODBC driver.

I need to understand how to pass a date as a parameter in a query to
get the results that I am looking for (ex. SELECT Job FROM
MASTER_JCM_JOB_1 WHERE Date_Stamp > #1/1/2000#).

I have many other queries that work fine, but they use text fields as
parameters. Depending on how I use the date I either get a syntax
error or an invalid date error. I have tried wrapping the date(s) in
brackets, braces, parenthesis, single quotes, and pound signs. I have
also had successful queries created in Access 2003 or MS Query 8.0 that
do not work when pasted into the code and run within the application.

Any help would be greatly appreciated.

That's the wonderful thing about standards -- there are so many from
which to choose!

Try specifying the date in ODBC format ( '2005-03-18' ) & see if that
helps. If Timberline did something like Pervaisve, then you can try
something like this ( {d '2005-03-18'} ), or even ( CONVERT(
'2005-03-18', SQL_DATE) ). One of these should work.
(In all examples, leave off the parentheses...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - July 19-22 ***
*** Chicago: Pervasive DataExchange Class - July 27-29 ***

jphilipps wrote: