一个关于datediff()的问题

[飞起来一脚]

为了提取论坛中在10天内回复(nreply)数量最多的一个帖子，sql语句如下：

sql="select top 1 id,name,title,date,father,nreply,nclick from forum where father='0' and "&datediff(d,date,now())&"<10 and top=false order by nreply desc"

但是显示出错了，错误就是在datediff()<10部分，请问那里错误了
其中date的表示的是forum表中储存发贴时间的列名

[cshadow]

sql="select top 1 id,name,title,date,father,nreply,nclick from forum where father='0' and datediff(d,date,now())<10 and top=false order by nreply desc"

[飞起来一脚]

还是不行

[飞起来一脚]

我用的是access数据库,win2000 professional ,iis5.0

[a_zhe_20]

sql="select top 1 id,name,title,date,father,nreply,nclick from forum where father='0' and datediff("d",date,now())<10 and top=false order by nreply desc"

[monkeys]

access好像不支持datediff

[飞起来一脚]

真的不支持？

[monkeys]

不好意思，弄错了那个函数，该da

sql="select top 1 id,name,title,date,father,nreply,nclick from forum where father='0' and datediff("d",date,now())<10 and top=false order by nreply desc"

[qunluo]

主要是不清楚你的数据库安排！
要不然可以想想其它方法！