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 "
