problem with timestamp in a query
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
"Martin Priebe" wrote in message
...
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
|