| || |
Setting Filter in Defects Module
It might seem like a very simple query. I want to set a favourite in my defects module that will give me all sev-1 issues that were opened 2 days prior to today.
I can easily get this through a query. But our manager wants to see this in the defects module as a favourite so he can pull it up easily.
The filter on 'Detected On' field takes [Today] for current day. I tried the following with no luck:
Does anybody know what is the formula we can use there to return the date for day before yesterday?
Re: Setting Filter in Defects Module
Unfortunately, you cannot make any date calculation in the filter criteria.
Moreover, unless you also work on week-ends, simply subtracting 2 from the current date won't give you the right answer on Mondays and Tuesdays.
I'd try to convince the user that [ThisWeek] is OK.
Come back to us if you fail to convince the user : an other (rather complicated) solution would be to define the favorite on the fly in the workflow.