Is there any way for to search documents between 2 date in Lotus Script, Java Script, etc. ?
Any idea, please.
Thanks.
Subject: RE: Search between 2 date field
There are many ways to search for documents in a range of dates.
If the database is full-text indexed, you can use the FTSearch method with an expression such as [fieldname] < 2/11/2005 and [fieldname] > 1/1/2005. That’s very efficient. If the date is not in a field (e.g. if it’s the last modified date) there are expressions you can use instead of a fieldname, documented in the Notes client help for full-text searching.
If not full-text indexed, you can use the Search method with a similar macro code expression. Not so efficient.
In either case, you can program a binary search thru a view that’s sorted by date; that’s more difficult to code but infinitely faster than the Search method.
Subject: Maybe an option.
Try something like this…
Use an input box to get the key value (actully you’ll add code to get a second key value, too)
Dim docA as notesdocument
Dim docB as notesdocument
Dim view as notesview
Dim key as string
…
key= Format(docA.datefield(0),“mm/dd/yy”)
set docB=view.getdocumentbykey(keys)