你可以改成这样试试:
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'"