View Selection Formula

HCL Domino Domino Forum
1

I apologize if this has been posted already. I’m sure this is a simple question, but the answer is totally escaping me.

I am trying to create a View Selection Formula that will select all documents that were modified within the last 3 days and display them in the view. I’ve tried using @Adjust(@Today;0;0;-3;0;0;0); SELECT @All, I’ve tried using this and comparing it to a field, I’ve tried using @Modified. Either every document is returned or no documents are returned. Can any one point me in the right direction?

2

Subject: View Selection Formula

Hollis,

I encourage you to search on Dev Network for “view performance” to see articles on this topic. There are performance considerations even when you do get your formula to work the way you want it to.

regards,

raphael

3

Subject: View Selection Formula

Is @Adjust(@Today;0;0;-3;0;0;0); your entire formula? Because you need to use @Adjust in comparison with some piece of info on the documents in order for it to work in a view selection.

SELECT @Date(@Modified) > @Adjust(@Today;0;0;-3;0;0;0);

4

Subject: RE: View Selection Formula

Thank you so much for your responses. This formula worked perfectly!