If I remove the ' from in front of the Today and Future with the dates in yyyy-mm-dd format it works fine.
That makes no sense.
If you do that, they you will be doing something like
... WHERE Cncrt_dateseq BETWEEN 2012-09-19 AND 2012-11-18 ...
and the SQL engine will see that as *SUBTRACTION*!! That is, it will see it as
minus 09 (==>>1993)
minus 19 (==>>1974)
At least with the '...' around those values I could see it working.
Are you *SURE* the values in the database look like '2012-10-03' and not 20121003 (that is, numbers)??
Take a screen shot of an Access display of the table data and show it.