Hi

I have an SQL between query, which searches an Access database for records between the two dates specfied, however I have noticed that it only looks at the dat number, and not the month or year, for example, say I specified the following date

23/03/2008
28/03/2008

It would return

25/03/2008
24/01/2008
27/09/2007 etc

Hes my sql query

Code:
sqlstring = "SELECT ID, Problem, SubmittedAt, Viewed FROM Table1 WHERE SubmittedAt BETWEEN #" & Olddate & "# AND #" & ObjDateToday & "# ORDER BY ID DESC"
Help appreciated