我想在数据库里查询介于某两个日期之间的所有文档，在代理里面怎么写查询语句呢？在网上搜到过： searchstr$=date([|+seldate1+|])<=Txgdsj_d & Txgdsj_d<[email protected]([|+seldate2+|]))|
Set dc=db.search(searchstr$,Nothing,0) 这个语句。但是实际发行有语法错误，哪位大哥告诉我正确的该怎么写呢？
------解决方案--------------------
strFormula = |Form = "MF_TimeSheetEntry" & txtTimeSheetOwner = "|+arrManHour(intTimesheetNum,0,0)+|"&@totime(datbusiness)>[email protected]("|+str1stDayofWeek+|")&@totime(datbusiness)<[email protected]("|+strLstDayofWeek+|")|
Set timesheetweekdc = timesheetdb.Search(strFormula,Nothing,0)
这样用
------解决方案--------------------
把它们拷贝到视图里看，会比较清晰