msflexgrids and dates

[aknighter]

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

[Bigley]

You might need to wrap the dates in # instead of ' and also you need to see what format your database expects the date. I am not sure if between works, if it doesn't you could always use > <.

Hope this helps

[StarE]

Originally posted by aknighter
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';")


Set Data1.Recordset = db.OpenRecordset("SELECT date,time,appointment From schedule where
date between #" & Format("November 3, 2000","MM/dd/yyyy")& "# and #" & Format("November 6, 2000","MM/dd/yyyy") & "#"