[RESOLVED] VB6/Access SQL string problem

[longwolf]

I'm writing a data base export module.
It's in VB6 using an Access 2000 DB
It has a table named 'tblRules' with a field named 'Updated'
The idea is to export only new or updated Rules from the table.
Here's the SQL string code:

    sSQL = "SELECT * FROM tblRules WHERE Updated BETWEEN #" & dtpStart.Value & "# AND #" & dtpEnd.Value & "#"

And here's a sample of the built string:

    SELECT * FROM tblRules WHERE Updated BETWEEN #9/20/2008# AND #10/11/2008#

The problem is, it's pulling all the records, including ones dated 9/18/2008