How do you select all the documents that are 2 months old

How do you select all the documents that are 2 months old

Subject: How do you select all the documents that are 2 months old

In what context? A view? If a view, hard-code the date into the selection formula, something like

Select @Created <= [10/29/2005]

then write a Lotusscript agent to run every day and change the selection formula. See notesview.selectionformula in Designer Help.

You could just use @Adjust(@Today) in the selection formula but this woud beat the hell out of the view indexer. Using @Today, @Tomorrow, @Yesterday or @Now in a selection formula is a very bad practice.

Subject: RE: How do you select all the documents that are 2 months old

One way is to have a view containing the documents and then in the view selection formula, apply @Adjust on the @Created and compare with @Today (you will need to see the syntax in the Help) to only make the desired documents appear.