关于datefiff的问题

[germ007]

rs.open "select * from zp_immune1 where datediff("m",time_real,date())=0",conn,1,3

这句有什么错误呢

[beyond_me21]

rs.open "select * from zp_immune1 where datediff(m,"&time_real&","&date()&")=0",conn,1,3

[beyond_me21]

你把变量和字符串搞混了，time_real和date()是你定义的变量，其它的sql语句是字符串

[germ007]

找到问题了
应该是

rs.open "select * from zp_immune1 where datediff(m,time_real,getdate())<0",conn,1,3

这是SQL的语法,测试通过,其中M什么也不能加,另外应该是GETDATE()才对.

[germ007]

谢谢关注,送分