🚀 go-pugleaf

Hi Vassiliev

Thank for your helping , I can able to query it now.

 Many Thanks.


"Vassiliev V.V." <news@vassilievvv.mtu-net.ru> ���g��l��
news:3d561d34_1@dnews...
> 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
> >
> >
> >
> >
> >
> >
>
>