求助!access转为sql server后datediff()出错

[jiacy219]

我把mdb数据库转为sql server后,下面代码出错.(asp代码)
rs2.open "select * from shop_action where (datediff(d,fhsj,"&day2&")>=0) and (datediff('d',"&day1&",fhsj)>=0) and (bookid="&rs("bookid")&")",conn,1,1
报错信息:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
另外day1,day2是这样定义的:
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"))&"'"
麻烦大侠们帮小弟看看,怎样才对呢?

[jiacy219]

自己搞定~~~
datediff(d,fhsj,"&day2&")> =0) and (datediff('d',"&day1&",fhsj
要转为
datediff(day,fhsj,"&day2&")> =0) and (datediff(day,"&day1&",fhsj

[snlixing]

response.write sql语句
看看就知道了