I am trying to build a formula in opportunities that will be used in a report to report on opportunities with a close date in the last three months (from last month).
So for example if I look at the report today I will see oppties from June, May & April and when I look at the same report on the 2nd August, I will see July, June & May.
I've been looking at constructing it based on the last day of the previous month -90 but need to consider the number of days in each month etc.
Then I thought maybe it would be done with month numbers - 3 each time.
Any examples you may have used would be much appreciated.
I am trying to build a formula in opportunities that will be used in a report to report on opportunities with a close date in the last three months (from last month).
So for example if I look at the report today I will see oppties from June, May & April and when I look at the same report on the 2nd August, I will see July, June & May.
I've been looking at constructing it based on the last day of the previous month -90 but need to consider the number of days in each month etc.
Then I thought maybe it would be done with month numbers - 3 each time.
Any examples you may have used would be much appreciated.
