Report on Incidents within the last 2 Months

torwcar
Kilo Contributor

When filtering Incidents in a report one can filter on Opened (date). Then there are options to filter "on Last Month" or "on Last 3 Months". However I want to filter for the "Last 2 months". How can I do that? Meaning, I am now in April, and I want all Incidents for February and March.

6 REPLIES 6

Mark Stanger
Giga Sage

You can do this by selecting the 'Relative' operator from the dropdown. That will allow you to specify any custom date range.


Thanks.
If I understand this correct the filter will then be "Opened between 2011-02-01 and 2011-03-01" ?
I have been thinking like this already, but when May comes and I shall have the report for the last 2 months, March and April, I will have to change the filter date range again. I am lazy and do not want to do that 😉 I just want to run the report for the "Last 2 months" without any adjustments in the quieries/filtering.


Use 'Relative', not 'Between'.


Ahh ! Now I see. Thanks