I have a RemoveDate field with the default value of @Adjust(@Today;0;0;30;0;0;0).The purpose is to not allow documents to appear in a view once this date has been reached. It is not working.
Any suggestions? Thanks!!
Subject: What is your view selection formula?
Subject: RE: What is your view selection formula?
The view selection formula uses the “Event” form (where this field is located) and field “Published” condition of published.
Subject: So it doesn’t make use of RemoveDate in anyway?
Which leads to the question, why do you think changing that will hide it from the view?
Subject: RE: What is your view selection formula?
So you’re going to need to add a condition to the selection formula. Something along the lines of & RemoveDay > @Today. Have you tried anything like that? You said it didn’t work, but it’s not at all clear how you’ve tried to make it work.
Going back to what I said, though, using @Today or @Now in a view formula can be quite problematic. There have been numerous discussions about the implications of “time-based views”. The basic problem is that time never stops changing, and Notes and Domino understand this, so the indexer will always assume that your selection formula might return a different set of documents every single time it runs. It marks the view as being in need of an update. This causes the Notes client to display an annoying little refresh icon constantly. More importantly, if the database is large and active the constant refreshes of the view can become a serious performance problem.
There are various techniques that people use to deal with this. Andre Guirard wrote several (as I recall) blog posts describing some of them. Here’s a link to a search of his blog: http://www-10.lotus.com/ldd/bpmpblog.nsf/dx/search.htm?opendocument&q=@Today
And here’s an IBM technote on the subject that I found via a Google search on “Lotus view @Today”: http://www-01.ibm.com/support/docview.wss?uid=swg27003557