ok This is the query i use to get data between startDate and endDate including if the dates entered are both today, it should return the record from only today.
However it does not the record set is eof. I have tried with "BETWEEN #" & CDate(startDate) & "# AND #" & CDate(endDate) & "# " with the same result an empty record set. However Data is in there.... Now if e.g i specify between two years it works like a charm... what is wrong???


objCommand.CommandText = "SELECT * From DataHead WHERE " & strList & " > 0 AND Finish = true AND DateCompleted >= #" & CDate(startDate) & "# AND DateCompleted <= #" & CDate(endDate) & "# Order BY CaseOfficer "

... there is always more to learn...

__________________
... there is always more to learn...

ok ... it kills me ... if i change the startDate let's say from 05/03/2004 and the endDate to 03/05/2006 it works great ... but even between 01/01/2005 and 12/31/2005 it does not pick the entry upi took the Cdate(startDate) out and put it before the SQL statement startDate = CDate(request.QueryString("start")) (same with endDate) an it still sucks ... sooooo frustrated

... there is always more to learn...

May be you have a wrong system date format , not the loggedin user but aspnet process (I_user...). Also try using the month abrv(jan,feb,...) instead of numeric.
You could print the CommandText and test directly in a access query window(if you have done, Is the result comming ok)

Prashant