日期查询类型不匹配

[rcsglydm]

第一个页面提供“开始日期”和“结束日期”，日期格式为2009-1-1。
下一个页面根据日期进行查询。
time1=request("time1")
time2=request("time2")
sql=select * from worklist where time>'"&time1&"' and time<'"&time2&"'" //此处，提示表达式中类型不匹配
rs.open sql,conn,1,3

请高手帮助。

[hookee]

sql server
sql="select * from worklist where DateDiff(d,[time],'" & time1 &"')<0 AND DateDiff(d,[time],'" & time2 & "'>0)"

access
sql="select * from worklist where DateDiff('d',[time],#" & time1 &"#)<0 AND DateDiff('d',[time],#" & time2 & "#>0)"

[hookee]

改下

sql server 
sql="select * from worklist where DateDiff(d,[time],'" & time1 &"')<0 AND DateDiff(d,[time],'" & time2 & "')>0" 

access 
sql="select * from worklist where DateDiff('d',[time],#" & time1 &"#)<0 AND DateDiff('d',[time],#" & time2 & "#)>0" 

[rcsglydm]

是在ACCESS中，字段为“日期/时间”。

[hookee]

access

sql="select * from worklist where DateDiff('d',[time],#" & time1 &"#)<0 AND DateDiff('d',[time],#" & time2 & "#)>0"

[toury]

sql="SELECT * FROM worklist WHERE time BETWEEN #"&time1&"# and #"&time2&"#"