Search date ranges
One of my users asked me to pass this along:
After some period of time there will be a lot of items in the database, many of them pretty old. At that point it would be nice to be able to limit the search to some shorter period of time. Perhaps a dropdown list similar to the "Opened" filter but with different times, e.g., "In the last week", "In the last month", "In the last year".
Alternatively, you could use a checkbox "Search only in filtered items" and NOT disable the current filter. We actually like this better because it allows much more refined searches. (But we'd want to see "In the last year" added to the Opened filter--the longest peiod (month) is too short.)
However it's done, it sure would be nice if there was a way for the search to exclude items that were closed years ago.
Friday, October 19, 2001
Are the dates/times of edits/changes stored in the database. I see the history is maintained in the text of the case, but is this queryable (SQL, access, excel)?
e.g. select cases opened or closed or reopened within a date range.
Friday, October 24, 2003
Fog Creek Home