28,391
社区成员
发帖
与我相关
我的任务
分享
kename = trim(Request("kename"))
date1=FormatDateTime(trim(request("date1")),vbGeneralDate)
date2=FormatDateTime(trim(Request("date2")),vbGeneralDate)
Select * From [takechu] Where corp_code='“&kename“' and (take_date between '”&date1&"' and '"&date2&"')
Select * From [takechu] Where corp_code='“&kename“' and DateDiff(d,[take_date],'"&date1&"')<=0 and DateDiff(d,[take_date],'"&date2&"')>=0
Select * From [takechu] Where corp_code='“&kename“' and ([take_date]>='"&date1&"' and [take_date]<='"&date2&"')