Document search db.search(), between dates

HCL Domino Domino Forum
1

hi,I am using db.search() method to retrieve the calendar documents which falls in between two dates.

I m using this

db.search (“((Form="Appointment")& (StartDate>= “12/12/03”) )” );

but every time whenever i run this program i m not getting 0 matches…

Could anyone please tell me whether this formula is correct or not… if not please then correct me…???

thanx in advance…

regards

Saini

2

Subject: Document search db.search(), between dates.

Get rid of the quotes surrounding your date:

db.search (“((Form="Appointment")& (StartDate>= 12/12/03) )” );

cheers,

Tom

3

Subject: RE: Document search db.search(), between dates.

i got the answer

@TextTotime(“12/12/2003”),…

this is the right way to do this…and if your fields are dynamically generated then give the DateTime object to @TextTotime()…

thanx

Saini

4

Subject: RE: Document search db.search(), between dates.

you can use dates in a direct way! Read my answer here →

5

Subject: use square brackets to indicate dates!

like this:

db.search (“((Form="Appointment")& (StartDate>= [12/12/03]) )” );

in formula language, dates have to be inclosed in square brackets!

BTW: you can make it more readable using curly brackets { }, avoiding these " combinations:

db.search ({ (Form=“Appointment”) & (StartDate>= 12/12/03) } );