🚀 go-pugleaf

When you specify the criteria argument, date literals must be in U.S.
format, even if you are not using the U.S. version of the MicrosoftR Jet
database engine. For example, May 10, 1996, is written 10/5/96 in the United
Kingdom and 5/10/96 in the United States. Be sure to enclose your date
literals with the number sign (#) as shown in the following examples.

To find records dated May 10, 1996 in a United Kingdom database, you must
use the following SQL statement:

SELECT *

FROM Orders

WHERE ShippedDate = #5/10/96#;


You can also use the DateValue function which is aware of the international
settings established by Microsoft WindowsR. For example, use this code for
the United States:

SELECT *

FROM Orders

WHERE ShippedDate = DateValue('5/10/96');


And use this code for the United Kingdom:

SELECT *

FROM Orders

WHERE ShippedDate = DateValue('10/5/96');



Regards,

Vassiliev V.V.

http://www.oledbdirect.com



"Jackie" <tkfi@hotmail.com> �������/�������� � �������� ���������:
news:3d55a14f$1_2@dnews...
> Hi All
> I have a Access database with several table which all have a (short date
> format) data type field , where i try to query it by execute the following
> SQL statement .
>
> Select * from table1 where dater =  31/7/2002
> or
> Select * from table1 where dater =  '31/7/2002'
> or
> Select * from table1 where dater =  #31/7/2002#
>
> I got nothing , I'm sure that at least one record have the date
"31/7/2002".
> did i do something wrong.
>
> Please help
> Thanks a lot
>
>
>
>
>
>