Need to copy value from LastModifiedDate field to another custom field

Question

We need to track the LastModifiedDate field. But LastModifiedDate is a standard field and not able to set to track the field history.

So, Is there any option to track that field?

Answer 1

1. Add a custom field Last_ModifiedDate__c
2. Track Field history on that new field
3. Use a before insert and before update trigger to set the value to System.now()

Answer 2

You need to Create a Custom Field of Type Date and you need to copy the value of Last Modified Date Field to the Custom Field.

You can do this via WF Rule OR Trigger.

Below is the step for WF Rule.

1. Create a WF Rule for the object.

2. In WF Rule Criteria, you can add the condition like this:

   ISCHANGED(LastModifiedDate )

3. In WF Action,You need to create WF Field Update. Specify the field that you want to update(in this case your custom date field).

4. In Specify New Field Value,click on 'Use a formula to set the new value' and add the below value: LastModifiedDate

5. Activate the WF Rule.
6. Verify if the value copies properly or not,if copied then you can track the custom date field in Field tracking history.

Let me know if it helps.

Answer 3

@Sfdcprog, Trigger is possible to track lastmodifieddate. i tried below code. this is helpful for you

 if(Trigger.isupdate){   
   for(Account a:Trigger.new)
  { 
    if(a.Test__c != system.trigger.OldMap.get(a.Id).Test__c){

        if(a.Test__c=='Active' && a.Test__c!=null){
               a.Last_Time_Changed__c= system.today();
          }
          else{
            a.Last_Time_Changed__c= null;
          }
    }


}