If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
problem with timestamp in a query
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
problem with timestamp in a query
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. -- Dave Hargis, Microsoft Access MVP "Martin Priebe" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|