I got a view with sorted date in the first column, using @Dblookup i can find documents for a particular date, but my requirement is to find documents within a date range i.e. with a start and end dates ? how do i accomplish this ?? i never done this type of thing before… so please help…
Thanks
Subject: use an agent
having views that are built on dates are very inefficient, place unnecessary load on your server and, for databases with a large amount of documents, will open slowly because they will need to always recalculate. The best way to display docs for a date range is to use a nightly agent to add a field on the documents that fall into the date range then use that field in your view’s select statement. If you don’t want to go this route you can set the view to refresh manually then use an agent or program doc to update the view once per day on a schedule during off hours.