developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum

developerWorks




Database search formula
Liza Davila 04/27/2006 08:02 AM
Domino Designer 6.0.2 CF2 Windows XP


I want to do a notesdatabase.Search but need help writing the search formula for it. I want to search all documents in the database that have a Form="Response", a field called "notify" have a value of "Yes" and it's creation date be today. This is what I tried, but it doesn't work:

searchFormula$ = {Form = "Response" & (@Date(@Created) = @Date(@Today)) & notify="Yes"}
Set coll = db.Search(searchFormula$,Nothing,0)

Any help will be appreciated!

Go back