access升级到sql server之后的问题

[w2000n]

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 SQL Server 错误 '80040e14'
第 1 行: '#' 附近有语法错误。

/admin/tjbb2.asp，行 52

[若白师妹]

rs2.open "select * from shop_action where (datediff(day,fhsj,'"&day2&"')>=0) and (datediff(day,'"&day1&"',fhsj)>=0) and (bookid="&rs("bookid")&")",conn,1,1

[叮咚叮咚叮叮咚]

access里面日期型用 #
sql server里面用 '