Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

last modified date for fields

Posted on by 70

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.

  • Suggested answer
    gisiquei Profile Picture
    gisiquei on at
    RE: last modified date for fields

    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,

  • J_C Profile Picture
    J_C 70 on at
    RE: last modified date for fields

    Thanks for confirming Charan,

    much appreciated :)

  • Suggested answer
    Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Super User 2024 Season 1 on at
    RE: last modified date for fields

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

  • J_C Profile Picture
    J_C 70 on at
    RE: last modified date for fields

    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?

  • PabloCRP Profile Picture
    PabloCRP 1,086 on at
    RE: last modified date for fields

    Hi, OOB field "modifiedon" has that info.

  • Suggested answer
    Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Super User 2024 Season 1 on at
    RE: last modified date for fields

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans