比较日期型字段问题

[lanblue]

y1=request.form("y1")
m1=request.form("m1")
d1=request.form("d1")
t1=DateSerial(y1,m1,d1)
y2=request.form("y2")
m2=request.form("m2")
d2=request.form("d2")
t2=DateSerial(y2,m2,d2)
set rs=server.createobject("adodb.recordset")
此时使用:
sqltext="select COUNT(zh) as sm,zh from OrderList where datediff('d',RegTime,t1)>=0 and datediff('d',RegTime,t2)<=0 and flag='已經發貨' group by zh"
rs.open sqltext,conn,1,1
会出错
而使用
sqltext="select COUNT(zh) as sm,zh from OrderList where datediff('d',regtime,date())<=6 and flag='已經發貨' group by zh"
rs.open sqltext,conn,1,1
不会出错

请问是何原因??????

[itzhiren]

把t1,t2转换成时间类型

[lanblue]

如何转?

[lanblue]

我已经使用t1=FormatDateTime(t1,1) t2=FormatDateTime(t1,2) 转不行

[lanblue]

T1变量和DATE()结果有何不同??????????

[vivid_0816]

T1是字符串，Date()是日期型的
在sql語句中用cdate（）轉一下T1試試

[lanblue]

还不行呀

[itzhiren]

把t1、t2的值输出到页面上看看是什么？