Sign Up ›
  • tsox6691
  • NEWBIE
  • 0 Points
  • Member since 2008
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
6 replies

I want to Capture the actual date an Opportunity was CLOSED (won or lost).

I find no way to capture the actual closed date (not the Close Date field which is open to user input).   Using formulas, i can address the isClosed field.  
 
Possibility 1:   i could like to use something like the following but a field formula cant reference itself.  
 
actual_closed_date__C = if (IsClosed = False, datevalue(LastModifiedDate), PRIORVALUE ( actual_closed_date__c ) )
 
 
Possibility 2:  if i coudl find a way to force the formula to not evaluate, i can simply do this
 
Actual_closed_date__C = if( isClosed = True, datevalue(lastModifiedDate), null)
 
 
Desparate to capture this field value. Any help appreciated.     On professional edition so Workflow's are not an option.
 
Thanks.