Manage Learn to apply best practices and optimize your operations.

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)

Dig Deeper on Domino Resources - Part 7

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials'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 ...