ASP+ACCESS时间段查询
DD表,查询fahuotime这个字段,用的是文本型,时间格式是YYYY-MM-DD格式,但是点查询没有反应,大家帮我看看怎么回事?
Response.Buffer =false
Response.Expires=-1
'thistoday =year(now)&"-"&month(now)&"-"&day(now)
dtfrom=trim(request("dtfrom"))
dtto=trim(request("dtto"))
if len(dtfrom)=0 then
dtfrom=year(now)&"-"&mm&"-01"
end if
if len(dtto)=0 then
dtto=thistoday
end if
sql="select * from DD where date(fahuotime) between '"&dtfrom&"' and '"&dtto&"'"