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