The table has a date field that is text. The SQL statement is:

```
"SELECT datefield, anotherfield FROM tablename WHERE CDate(datefield) BETWEEN #" & dateStart & "# AND #" & dateEnd & "#"

```

`dateStart` and `dateEnd` are strings, like "10/02/2017" and "10/4/2017". I used `CDate` to convert the string `datefield` to a date, and the bracketing # around the start and end date strings so that they will be treated as date. I have tried, literally, dozens of different variants of the WHERE clause with no luck. Any suggestions are appreciated.