access 转sql 数据库遇到的语句,请高手解决(100)

day1="#"&trim(Request.Form("month1"))&"-"&trim(Request.Form("day1"))&"-"&trim(Request.Form("year1"))&"#"day2="#"&trim(Request.Form("month2"))&"-"&trim(Request.Form("day2"))&"-"&trim(Request.Form("year2"))&"#"rs.open "select * from orders where (datediff('day',fhsj,"&day2&")>=0) and (datediff('day',"&day1&",fhsj)>=0) and (bookid="&rs("bookid")&")",conn,1,1这句是access数据库下的asp语句 正确的 怎么样把它改成sql server2000数据库用的asp语句呢？

day1="'"&trim(Request.Form("month1"))&"-"&trim(Request.Form("day1"))&"-"&trim(Request.Form("year1"))&"'"day2="'"&trim(Request.Form("month2"))&"-"&trim(Request.Form("day2"))&"-"&trim(Request.Form("year2"))&"'"也就是说把#换成'，试试？

谢谢 haidy 这个方法我试过了不行，执行很慢，最后还是没查出来接过来。

没有人回答了吗？肯定高手来解决 分不够可以再加100分

也就是说把#换成'convert(DateTime,"&day2&")

也就是说把#换成'convert(DateTime,"&day2&") 怎么加到代码里面去呢？