按日期搜索

time1=#2004-10-10#
time2=DateAdd("d",1,time1)
time3="#" & time1 & "#"
time4="#" & time2 & "#"
"SELECT * FROM rizhi WHERE rz_employee = 'user' and time between " & time3 & " and " & time4

---

 time2 = request("to")
 tempdate = CDate(time2)
 tempdate2 = DateAdd("d",1,tempdate)
 time2 = "#" & time2 & "#"
 end_time = "#" & tempdate2 & "#"
 "SELECT * FROM rizhi WHERE rz_time between " + time2 + " and " + end_time + " ORDER BY rz_ID DESC"