Report: Inactive opportunities

Hi Kristjan,

I would probably recommend using the "is between" operator for the filter so that you can choose to display all of the opportunities last modified between two specified dates.  You could select something like 01/01/1999 as your first date (unless you happen to have opportunities from prior to 1999 that you want to include) and then you could choose 10 days ago as your second date, as shown in the following screenshot:

There might be a few other ways to do this, but I think that this would likely be the most straightforward.  Please keep in mind that if you are going to be using this report long-term into the future, you will have to change the second date on the filter to represent the date that was 10 days ago.

Regards,

Patrick Sullivan

SugarCRM Support

Hi Kristjan,

I would probably recommend using the "is between" operator for the filter so that you can choose to display all of the opportunities last modified between two specified dates.  You could select something like 01/01/1999 as your first date (unless you happen to have opportunities from prior to 1999 that you want to include) and then you could choose 10 days ago as your second date, as shown in the following screenshot:

There might be a few other ways to do this, but I think that this would likely be the most straightforward.  Please keep in mind that if you are going to be using this report long-term into the future, you will have to change the second date on the filter to represent the date that was 10 days ago.

Regards,

Patrick Sullivan

SugarCRM Support

Thanks Patrick for your input.

But that´s the thing, this report needs to be dynamic in order to be scheduled. I assume that both dates in your example are fixed and would not change at the time this report´s schedule would run, correct?