🚀 go-pugleaf

AND ([DateTime] >= #07/15/2002 00:00:00#)

always in US format = #mm/dd/yyyy hh:nn:ss#

Also may VBScript functions are usuable

AND ([DateTime] < DateSerial(2003, 07, 16) + TimeSerial(00, 00, 00)

< DateSerial(2003, 07, 16) is better in your case than <= DateSerial(2003,
07, 15) + TimeSerial(23, 59, 59) because it includes 2003/07/15 23:59:59.5

Note brackets around DateTime - it is very likely the keyword.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"afatdog" <afatdog.hn@yeah.net> �������/�������� � �������� ���������:
news:3f14100d@newsgroups.borland.com...
> I use TADOConnection to connect a database, Access 2000.
>
> ADOQuery->SQL->Add("select");
> ADOQuery->SQL->Add("    *");
> ADOQuery->SQL->Add("from");
> ADOQuery->SQL->Add("    T_XXXX");
> ADOQuery->SQL->Add("where");
> ADOQuery->SQL->Add("        (.....)");
> ADOQuery->SQL->Add(" AND (DateTime >= #2002-07-15 00:00:00#)"); // here
> ADOQuery->SQL->Add(" AND (DateTime <= #2003-07-15 23:59:59#)"); // here
> ADOQuery->Open();
>
> There is some exception was throw : "Parameter object is improperly
defined.
> Inconsistent or incomplete information was provided".
> But this SQL can be correct execute in Access.
> Where is wrong?
>
>
>