Db.search formula

HCL Domino Domino Forum
1

hi can any one tell is this formula correct .

searchFormula$ = { Form = “MainTopic” & Subject =doc1.Subject(0) & DueDate = Date}

Set collection = db1.Search(searchFormula$,Nothing,0)

i get an error as Notes error: Formula Error

2

Subject: Db.search formula

If you’re not sure about the search syntax you call always paste the actual string into the search box manually and it should tell you if it doesn’t like it. Once you have something that works, then code it.

3

Subject: Db.search formula

try adding square brackets around Date:

[Date]

4

Subject: Db.search formula

Try:

searchFormula$ = { Form = “MainTopic” & Subject = “} & doc1.Subject(0) & {” DueDate = “} & Date & {”}