last modified date for fields

(0) Share

Report

Posted on by J_C

Hi All,

I have a look up field called "competitors" in my company entitiy, i want to know the time stamp of when this field was last edited. I currently dont have any custom fields that store the modifed date for competitors.

is it possible to retrieve this information?

Thanks.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Charan Raju C R 7 Moderator on at

Like (0)

Report

Hi J_C,

You can follow one of the below solutions

1. Enable audit history for this entity and field, and check the history of this field changes.

2. Create a separate Date Time field to capture Competitor field modified date. Then register a plug-in on update of Competitor field to set this Date Time field.

Was this reply helpful? Yes No
PabloCRP 1,088 on at

Like (0)

Report

Hi, OOB field "modifiedon" has that info.

Was this reply helpful? Yes No
J_C 70 on at

Like (0)

Report

Hi Charan,

Both solutions work for tracking mod_date moving forward. However, i need to find the previous mod_date. unfortunately, i didn't have auditing turned on.

is there a way to do this?

Was this reply helpful? Yes No
Suggested answer

Charan Raju C R 7 Moderator on at

Like (1)

Report

Unfortunately we cannot track if the audit history was not enabled.

Was this reply helpful? Yes No
J_C 70 on at

Like (1)

Report

Thanks for confirming Charan,

much appreciated :)

Was this reply helpful? Yes No
Suggested answer

gisiquei on at

Like (0)

Report

Hi J_C,

I agree with Charan. Best approach would be have audit enabled and this will track all the future changes for the desired field.

If Audit is not an option, maybe you could also test the following:

Create an additional field on this form like 'previous modified on'-> Create a sync workflow that triggers before the original 'modifiedon' field changes so the wf could update the additional field .

Thanks,

Was this reply helpful? Yes No