Search formula error

HCL Domino Domino Forum
1

I am getting error using searchformula code. I want to do search by date and department.query$ = workspace.Prompt (PROMPT_OKCANCELLIST,“Select a Date”, “Select one Employee Meeting Date from below list.”, result, result)

query1$ = workspace1.Prompt (PROMPT_OKCANCELLIST,"Select a Department", "Select one Department from below list.", result1, result1)

searchFormula$ = {Form = “back” & Date = @texttotime(" }& query$ &{") & Dept = }& query1$ &{}

I am geting Noteserror message.

please help

2

Subject: search formula error

As far as I remember in SearchFormula it has to be in Search format - look for query_search in help.

It goes something like :

FIELD Form=“YourForm” And FIELD Dept=“SomeDept” AND FIELD CreatedDate > [01/01/2006]

3

Subject: RE: search formula error

Thanks for you suggestion. I got it working.