I posted Lotus Notes documents by Date keys a while ago, and the date keys worked, and the date ranges seemed to work, but later I found that the ranges worked only if all of the documents were from one particular date. If the date range spanned two or more groups of documents, only documents from one particular date were returned. Can anyone confirm or deny whether date ranges in Lotus Notes (from perl) work? Here is some code, the database/view/field names and the date range would have to be adjusted as appropriate:

use strict;
use warnings;

use Win32::OLE;

my $Notes = Win32::OLE->new('Notes.NotesSession')
    or die "Cannot start Lotus Notes Session object.\n";
my $Database = $Notes->GetDatabase('server', 'dbfile.nsf');
my $View = $Database->GetView("By Start Date");

my $date_range = "03/01/07 - 03/31/07";
my $DateRange = $Notes->CreateDateRange();
$DateRange->{Text} = $date_range;

my $Entries = $View->GetAllEntriesByKey($DateRange);
my $Entry = $Entries->GetFirstEntry();

while ($Entry) {
  my $doc = $Entry->Document();
  my $subj = $doc->GetFirstItem('Subject')->{Text};

  print "Subject: $subject\n";

  $Entry = $Entries->GetNextEntry($Entry);
}
[download]