• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Last Modified View

Hi...
I'm trying to create a view that would capture only documents that have NOT been modified within the last ten days.  

This view would be updated daily.

Example:
A document was created on 03/20/2002. It was updated and saved on 03/23/2002.  If no other updates are made to the document, I would expect to see this document appear in my view on 04/04/2002.

Is there any way to do this?

Thanks.
0
Aquilon7
Asked:
Aquilon7
1 Solution
 
HemanthaKumarCommented:
This can be controlled by view selection formula

Goto design of the view and select "View Selection" entity from the list

Then select easy "Easy" from the Run combobox.

Click "Add Condition" button

This will bring up a dialog with options, In that select by date as condition

Then select "date modified" from the search combobox. You will have lots of option, and one which you would want is "Is Older Than", and set number of days.

And save the changes, and you should be all set.

~Hemanth
0
 
ArunkumarCommented:
Try this view selection formula...

SELECT (@Date(@Today) - @Date(@Modified)) / 86400 >= 10
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now