Excel Export based on criteria

HCL Domino Domino Forum
1

Hi all

I need to export the documents based on the start date & date end that user selects.I h ave tried with searchformula=“Select form =“test” & mydate>=“uidoc.startdate” & mydate<=“uidoc.enddate””

But the above formula is not working.

I don;t know what i am missing.Something with the concatenation .but dont know how to fix it/

Thanks & Regards

Shobana J

2

Subject: Excel Export based on criteria

Hi,

Try using like this …

searchFormula$ = | Form = ‘test’ & mydate>= | & uidoc.startdate(0) & | & mydate<= | & uidoc.enddate(0)

Set DocCollection = db.search(searchFormula$, Nothing, 0)

Thanks,

Saswat