Test for date in range of dates

HCL Domino Domino Forum
1

Hi,

I am trying to create a calendar view to show all appointments for today. This includes events spanning more than one day where today is one of the days the event is occuring.

I have created the following Select formula that works for one off events but it shows all repeating events that occurr before or after today (e.g. birthdays).

datToday := @TextToTime(“Today”);

SELECT (Form = “Appointment”)

&

(StartDateTime <= datToday & EndDateTime >= datToday)

I’m sure this is a simple problem but my brain is a bit mushy this morning!

Any help would be greatly appreciated.

Thanks in advance.

Richard

2

Subject: Test for date in range of dates

Why not use the existing calendar template? That’s the best way to learn how to deal with creating your own calendars.

3

Subject: RE: Test for date in range of dates

Hi Esther,

I have gone through my mail file and can’t find anywhere that does quite what I’m after.

In effect I want to achieve the result you get by creating a view with Calendar style and only showing 1 day. The thing is I don’t want all the extraneous stuff that a Calendar view brings (such as scroll bar at bottom of view to move to next/previous day). I have turned off all the Calendar features but it’s still not how I want it so I have resorted to using a regular view.

I’m still drawing a blank but I’ve started a complex approach using @IFs and @DO. I’ll post it if it works.

Richard