Calendar View of Past Events

HCL Domino Domino Forum
1

Hello!I need to create a view that only displays last months entries. I’ve searched for column formulas but the problem has been with repeating entries.

2

Subject: Calendar Schema

The calendar schema has a section explaining the repeat model.

I think you’ll need to look in the repeatdates field to find the items you want.

3

Subject: Calendar Schema

Thanks for the reply… Would I be looking to modify the view selection or a column?

4

Subject: Solution

Anyone looking to create a view of just past calendar entries here’s the code. Thanks to Charles at IBM.

taskTime := @If(TaskType = “2” & startDate != “” & startDateTime = “”; StartDate; @Date(StartDateTime));

MyView:=@If(

form = “Notice” & @IsAvailable(CalendarDateTime);CalendarDateTime;

@LowerCase(form) = @LowerCase(“TasK”); taskTime;

AppointmentType = “3” & !@IsAvailable(PostedDate) & Repeats = “1”; CalendarDateTime;

AppointmentType = “3” | AppointmentType = “0” | AppointmentType = “4” ; StartDateTime;

@IsAvailable(StartDateTime); @Date(startdatetime); “”);

SELECT @IsAvailable(CalendarDateTime) & MyView<=@Adjust(@Date(@Now);0;0;-1;0;0;0)