Closed Documents

Hi Dears,

I have one issue, How to get the before 2 yrs old closed documents in a view from the current yr. I had tried using this formula “SELECT @Created > [01/01/2006] & @If(@Created >= [01/01/06];“Form”;“NewForm”)” from Form Formula in view but no results. Can any one have idea please let me know.

Thanks in advance

Thanks!

Sree

Subject: Closed Documents

A form formula tells notes which form to use when displaying a document, not which docs to display in the view.

You need to select the docs using the view selection formula.

Using dates is bad practice (slows down the view) so an alternative would be to run an agent that sets a field value to something you can then use as a selection criteria.

If you just need to be able to find these docs, just do a date based search.

HTH

Doug