Fog Creek Software
Discussion Board




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.

Chris Dunford
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.

Trevor Hughes
Friday, October 24, 2003

*  Recent Topics

*  Fog Creek Home