[RESOLVED] Dates in SQL Query

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

It sounds like the SubmittedAt field is a Char/Text data type, rather than a Date data type.

Another possible issue is the format of Olddate and ObjDateToday.. to be reliable, they need to be in either US (mm/dd/yyyy) or ISO (yyyy-mm-dd) format.

I forgot I changed the Data type to text whilst testing last week, oops.