more general/relative filters on date fields

mrouchal

We would like to be able to create more general filters on date fields; the current asks by our user community are:

• “Which items are due within the next X days?”
• “Which items are due this week?”

Our items have a due date field, but unfortunately the filter only allows to “look back” into the past, by using “is within the last” (days), and even that does not allow to pick an arbitrary number of days (only a fixed selection list).

We propose the following enhancements of the Jama date filter capabilities:

1. Introduce two date filtering options: “is within the last days” and “is within the next days”
2. The above shall have an integer number parameter: number of days
3. Optionally, there may be also another filter: “is between days (relative to today)” with two integer parameters, which may be positive or negative; this would allow to filter for last week/next week with “-7, +7”, or a range in the future (e.g. +7, +14), or in the past (e.g. -60, -30)
4. The existing queries “is”, “is on or after”, “is before or after” should accept a “TODAY” macro, which evaluates to the current date when executing the filter.
5. We also could use some way to work with calendar weeks, including the notion of “this week”.