I am soliciting for help with the Opportunity Entity form. One of the fields on the form is Rating and i have several options E.G Hot, warm, cold etc. What I want done is, every time the rating changes from one phase to the another, there should be date associated with it. That is each phase should have a date to show when and how long it was on that phase.
That is, if the opportunity was on cold on, say, May 15, and then on May 20 the phase is changed to warm. I want to be able to catch that on my report to say that on May 15, the rating was on cold and on warm on May 20.