Can someone help us please. The requirement is, once the Closed case was reopened and then Closed it again the Closed Date/Time should return to its original Closed Date/Time when the case was closed for the first time.
We created a field Date/Time and a Workflow rule that everytime the Closed Date/Time ischanged, a Field update will fire. The Field update is change the created field to the formula PRIORVALUE(ClosedDate).
Here is our workflow criteria:
ISPICKVAL(Status, "Closed") )
Created field (Date/Time datatype)
will have a formula like this.
Thank you in advanced!