通过SQL语句查询两个日期之间的记录

[Dabeng]

我要查询介于date1和date2这两个日期之间的记录，以下是查询的代码，可是有错误，提示说日期语法不对，请高人指点。
dim date1,date2
date1=request.form("date1")
date2=request.form("date2")
set connect = Server.CreateObject("ADODB.Connection")
Connect.open "DSN=board"
SQL="select* From Message where Date>=#date1# And Date<=#date2# Order By Time Desc"
set rs=connect.Execute(SQL)

[bingofei]

select* From Message where Date between Date1 and Date2 Order By Time Desc

[baikaishui_0825]

SQL="select* From Message where [Date] between #"&date1&"# And #"&date2&"# Order By Time Desc"