problem with timestamp in a query

[Martin Priebe]

Hello,

i use access 2002
i created datarows with a timestamp (18.07.2007)

My Query is ..

SELECT DISTINCT *
FROM tData p
WHERE p.timestamp<#31/07/2007#

It works.


But ..
SELECT DISTINCT *
FROM tData p
WHERE p.timestamp<#02/08/2007#

Here i have no result


But...

SELECT DISTINCT *
FROM tData p
WHERE p.timestamp<#08/08/2007#
...works fine.

When my Day is smaller 8 i got no result.

Could anybody help me ?


greetings
Martin

 

[Jeff Boyce]

Martin

This might be related to the difference between m/d/y and d/m/y date
formatting. As I recall, Access requires use of "american" date formats in
query criteria, even if the Windows setting is not (but I may be
mis-remembering).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Klatuu]

I believe Allen Browne has what you need for this. Go to this site:
http://www.allenbrowne.com/ser-36.html#Interface
and look for "2. Wrong Formatting in Code" That should give you what you
need.