Question on how to modify resource reservations views

HCL Domino Domino Forum
1

Hello!

I was assigned a task: in all views of the resource reservations database, only show the reservations that have been in place for 2 days in the past as well as all future ones. Eliminate those old ones from the view selection.

It looks very simple. But when I tried to add something like: & @date(StartDate) >= @Date(@Today), & @Date(@StartDateTime) >= @Date(@(@Today), and & @Date(ReserveDate) >= @Date(@Today), at the end of the view selection, They neither don’t change anything at all in the views, nor don’t include all the reservations created in the past even there are repeated items in the future.

Which date field I should use in the view selection to get the current reservations OR what I should do differently to only show the current reservations in all views.

Is there anyone here can help me out?

Thanks!

2

Subject: question on how to modify resource reservations views

I tried to do this too, using a very similar formula to the one you tried. However, any repeating entries for reservations originally created before the view selection date (i.e. old ones) didn’t show, though it did otherwise work. I have since removed the changes because of this and therefore can’t tell you exactly what we put in. The StartDate is a multi-value field which contains all dates for repeating entries. I guess you would need to say that the startdate doesn’t contain any dates earlier than two days ago, that way if there are still future dates it should still show them. I haven’t tried it yet as I was waiting to upgrade to R6, but I will be trying it fairly soon. If it works for me, I’ll let you know.