28,391
社区成员
发帖
与我相关
我的任务
分享
strSQL="select * from table where 1=1 "
strSQL=strSQL&" and order_data >= #"&cdate(sd)&"# "
strSQL=strSQL&" and order_data <= #"&DateAdd("d",1,CDate(ed))&"#"
sql="select * from table where datediff('d',pubtime,'"&startdate&"')>=0 and datediff('d',pubtime,'"&enddate&"') <=0"