First let me thank you all for the responses to yesterday's conundrum. Lots of great ideas, one of which I've now switched to using. The solution I originally came up with seems kind of stupid now. Let me describe that first.

I had created a Folder call "EventsNextWeek". The first column was sorted on the EventDate field. Obviously the folder started out empty. To fill it involved two steps. First a nightly Agent to build/refresh its contents. The Agent's code was as follows:

Set collection = db.Search({Form="Event" & @Today<=EventDate
& EventDate<=@Adjust(@Today;0;0;7;0;0;0)}, Nothing, 0)
Set folder = db.GetView("MeetingsNextWeek")
folder.AllEntries.RemoveAllFromFolder("MeetingsNextWeek")
Call collection.PutAllInFolder("MeetingsNextWeek")

This alone is required merely to move new Events in and the old ones out, on a daily basis. However, it doesn't deal with new Event documents created where the EventDate value falls in the next seven days or where Event documents are edited and the EventDate value moves outside the time slot we're interested in. Obviously these documents need adding/removing from the folder straightaway. To do this I had used a combination of WQS/WQO Agents. At first I'd thought a WQS would do, but I found you can't add a new document to a folder the first time it's saved. In this case I had to pass a URL parameter to the WQO Agent using the $$Return field on new documents. This is the point where I started to consider it a hack.

Thankfully, yesterday, Gerald Mengisen suggested a much better solution using a new Domino 6 View property called SelectionFormula. You can now set the View's selection formula in LotusScript! I've scrapped my folder and WQS/O Agents. Instead I have a normal view and a modified nightly Agent. The code for the agent is now:

Dim nowDateTime As New NotesDateTime(Now)
Dim thenDateTime As New NotesDateTime(Now)
Call thenDateTime.AdjustDay(7, True)
Set view = db.GetView("MeetingsNextWeek")
selection = {Form="Event" & EventDate >= [ } + 
nowDateTime.DateOnly + { ] & EventDate <= [ } +
thenDateTime.DateOnly +{ ] }
view.SelectionFormula = selection
Call view.Refresh

So, each day, the View only shows Events in the next seven days. It does this without the performance nightmare of having to use @Today in the selection formula. If a new Event is added or removed the View index updates straightaway. Thanks Gerald.

Another suggestion was to use GetAllEntriesByKey() with a list of dates. I've not tried this, but I'm assured it works. The reason I didn't use this is that there are other views I need to use this approach for (one merely to show future meetings) and so one nightly Agent made more sense.

Thanks for all the feedback guys. What must a SQL developer make of all this?! From memory the (My)SQL code needed to find next week's meetings would be something like below. No need for nightly agents or extra views.

SELECT * 
 FROM Events 
 WHERE EventDate  BETWEEN CURDATE() AND ADDDATE(CURDATE(), 7) 
 ORDER BY EventDate ASC

The important line here is the last one - ORDER BY. All Notes needs is a better way of sorting search results. The NotesDatabase Search method needs an ORDER BY parameter to save all this faffing about.