你可以改成这样试试：
sql="select * from zs_news edit_time where DateDiff('d', edit_time, '"&dates&"') =0 "
或者：
sql="select * from zs_news edit_time where DateDiff('d', edit_time, dates) =0 "
sql="select * from zs_news edit_time where DateDiff(d, edit_time, "&dates&") ='0'"
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024