Sqlggxx1 = "Select id,title,shijian,riqi From [zhanhui] where DateDiff( "d ",now(), riqi) <10 Order By riqi Desc "
我想让他显示管理员发布的开会日期与本日相差10天的的日期
比方说 今天是15号,我只让他显示5号到15号 15号到25号的 25号以后的不显示 5号以前的也不显示
SQL语句该怎么写?上面的好象不对~
提示语句未结束
------解决方案--------------------
Sqlggxx1 = "Select id,title,shijian,riqi From [zhanhui] where riqi between date()-10 and date()+10 Order By riqi Desc "