Help!

I was just wodering if anyone knows how to create an SQL string for a database where it would select from a table a range of dates. This code errors out to do with the dates.

Dim db As Database
Set db = OpenDatabase(App.Path & "\adpdumb.mdb")
Set Data1.Recordset = db.OpenRecordset("SELECT date,time,appointment From schedule where date between 'November 3, 2000' and 'November 6, 2000';")

Thanks,

aknighter