Access Database query help please????

[Bretto]

Can someone please help me with this I have benn looking at it for far to long.

I am connecting to an Access database using an OleDBConnection in an ASP.Net page written in C# and for some reason this query does not return the required results.

Select TimeStamp, ClientIP, Ident, URI From SquidAccessLog where TimeStamp Between #28/02/2005 6:54:16 PM# AND #1/03/2005 6:54:16 PM# AND Ident='lindsaybit\administrator' order by TimeStamp Asc

I am expecting results starting at 28/02/2005 6:54:16 and ending at 1/03/2005 6:54:16 but I am getting results between 27/02/2005 11:45:19 PM and 28/02/2005 12:14:57 PM.

I have run the same query with access to see if it was one of my time functions causing the problem and I am getting the same result.

Please Help

 

[Isadore]

Bretto: Have you tried this same query using the following date format?

#2/28/2005 6:54:16 PM#

..as a test? (i.e., mm/dd/yyyy)

 

[ca8msm]

Bretto - I would follow Isadore's advice - Try creatin gthe query actually in MS Access (in the design window) ad then have a look at the SQL it has generated. It may give you a clue as to whether it is a date format problem.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[Bretto]

Cheers GuysThat was it.

I new I had spent far to much time on this for it not to be something simple.

Thanks heaps