查询问题

[black1983]

目的：查询一定添加时间内的
startdate=DateAdd("y",-1,Now())
rs_news.Source="Select newsid From news Where adduser="&rs_user("userid")&" And addtime>"&startdate

[black1983]

up

[mjpclab]

startdate=DateAdd("yyyy",-1,Now())
rs_news.Source="Select newsid From news Where adduser="&rs_user("userid")&" And addtime>#" &startdate& "#"

sql server 数据库则把 # 改为 '

[mjpclab]

startdate=DateAdd("yyyy",-1,Now())
rs_news.Source="Select newsid From news Where adduser="&rs_user("userid")&" And addtime> #" &startdate& "#"

sql server 数据库则把 # 改为 '