|
Subject:
|
Count Dates
|
|
Posted By:
|
Odifius
|
Post Date:
|
9/22/2006 10:53:19 AM
|
I have this SQL query to find the number of dates in a table between these two dates. Now I want to know how many dates there are. I tried to use count but it didnt work. Any help would be greatly appreciated.
SELECT Cans.FitDate
FROM Cans
WHERE (((Cans.FitDate)>#6/23/2005# And (Cans.FitDate)<#6/30/2005#))
WITH OWNERACCESS OPTION;
JR
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
9/25/2006 2:26:58 PM
|
Do you want to know the number of DAYS between those two dates, or the number of dates in records in your database that fall between those two dates?
mmcdonal
|
