0

I have two custom fields, Tracking_record__c (Date Type) and Tracking_Update__c (Formula Date Type), both are Date Type;

If i change Tracking_record__c (1/1/2017), Update the Tracking_Update__c (get the Previous Value) then I change the Tracking_record__c (1/2/2017). get the Previous Date Value(1/1/2017). How to solve this problem could you please give any suggestions to me...

Improve this question
3
  • This is not possible with a formula field. As mentioned in an answer to your previous question here: How to track previous Dates using formula field, formula fields don't store values. You should use a workflow rule for this instead (or just use the standard field history functionality).
    – martin
    Commented Mar 6, 2017 at 9:50
  • @martin , I did Using Workflow, That is not a matter, i need to use formula Field ... that is a problem ..
    – user37856
    Commented Mar 6, 2017 at 9:53
  • Why do you need to use a formula field?
    – martin
    Commented Mar 6, 2017 at 9:54

1 Answer 1

Reset to default
1

I would use a workflow and a field update to write the old value in a field in a date field like

PRIORVALUE(Tracking_record__c)
Improve this answer

You must log in to answer this question.