delete from taobook where gonggaobz>=1 and taopai<>1 and DateDiff('d',ldatetime,date())>=3
其中，红色部分色花什么意思？

DateDiff('d',ldatetime,date())>=3
d表示day（单位）
ldatetime,和date()之间的天数之差大于3
用date()-ldatetime

为什么执行时提示 'date' 不是可以识别的 函数名?

二楼的说的对呀，呵呵

[QUOTE]delete from taobook where gonggaobz>=1 and taopai<>1 and DateDiff('d',ldatetime,date())>=3[/QUOTE]

access数据库行

sql数据库中
delete from taobook where gonggaobz>=1 and taopai<>1 and DateDiff('d',ldatetime,getdate())>=3

delete from taobook where gonggaobz>=1 and taopai<>1 and DateDiff('d',ldatetime,"&date()&")>=3
这样应该行 或者
delete from taobook where gonggaobz>=1 and taopai<>1 and DateDiff('d',ldatetime,getdate())>=3