Use Nothing for cutoff date in NotesDatabase.Search

This tip describes how to use nothing for cutoff date in NotesDatabase.Search.

Many Notes developers have learned to use a date far in the past to limit search results, when they really want Search to return all results regardless of date. Example:

Dim dateTime As New NotesDateTime("12/01/94")
Set collection = db.Search(searchFormula$, dateTime, 0)

This is wrong for two reasons.

First, it's inefficient to do the unnecessary test of last modified date.

Second, the way the date is specified makes this code incompatible with systems that represent dates differently, e.g. Japanese computers use yyyy/mm/dd, so the string "12/01/94" is not a valid date.

If you want all search results regardless of date, use Nothing as the date argument, e.g.:


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

This was first published in August 2002

Dig deeper on Domino Resources - Part 7

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close