between dates 1

[tuzojazz]

Hi:

I have a table named "Calls"

Calls
----------------------------
Id Date
----------------------------
2 04/04/2006 11:33:07
3 04/04/2006 11:35:27
-----------------------------

Both records have the same date but different time

When I make this query I don't get records
-------------------------------------------------
SELECT Id, Date
FROM Calls
WHERE Date BETWEEN #4/4/2006# AND #4/4/2006#
-------------------------------------------------

Why I don't get records If all records in table "Calls" have 04/04/2006 on column "Date"?


Thanks!

 

[r937]

because the column contains datetime values, not date values



when you say this --

BETWEEN #4/4/2006# AND #4/4/2006#

it is the equivalent of this --

BETWEEN #4/4/2006 00:00:00# AND #4/4/2006 00:00:00#

and of course there is only one exact datetime that will satisfy that particualr condition

r937.com | rudy.ca