?
Solved

Last Modified View

Posted on 2002-04-02
2
Medium Priority
?
215 Views
Last Modified: 2013-12-18
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
Comment
Question by:Aquilon7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 200 total points
ID: 6913667
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
 
LVL 9

Expert Comment

by:Arunkumar
ID: 6913862
Try this view selection formula...

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question