时间字段如何比较大小！！！？？？

[emilyxie]

我的SQLSERVER2000里有一个smalldatetime型字段lasthits，我想找出本周的所有字段，可为什么找不出来？？
dim OldWeek,NewWeek
OldWeek = WeekDay(Date())-1
If OldWeek = 0 Then OldWeek = 7
OldWeek = Date()-OldWeek
NewWeek = Date()+(9-WeekDay(Date()))
oldweek=formatdatetime(oldweek,2)
newweek=formatdatetime(newweek,2)
set rs_week=server.createobject("adodb.recordset")
sqlxx="select id,showname,weekhits from download where "
sqlxx=sqlxx&" (lasthits < " & NewWeek & ") And (lasthits > " & OldWeek & ") "
sqlxx=sqlxx&" order by weekhits desc"
rs_week.open sqlxx,conndown,1,1
为何找不出记录？？？？ 比较时间的那里好象没有起作用！！！为何？？？？

[ruyedian]

sqlxx="select id,showname,weekhits from download where "
sqlxx+="(lasthits between DateAdd(day, -7, '" & Date() & "' AND '" & Date() & "')"

[ruyedian]

sqlxx+="(lasthits between DateAdd(day, -7, '" & Date() & "')
这里少了个“）”不好意思

[emilyxie]

好了，谢谢