Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Answered

Is there a way to filter by the modified date of a specified field? (not the latest modified date)

Posted on by 15

Hi all, I have a date field and I want to filter by the modified date which updated the date field by the user. 

  • Bhone Profile Picture
    Bhone 15 on at
    RE: Is there a way to filter by the modified date of a specified field? (not the latest modified date)

    Thanks Steve! That's what my developer suggests to do. I'm just exploring whether there is alternative way without creating a new field. Seems like it is the only one. Really appreciate your help.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there a way to filter by the modified date of a specified field? (not the latest modified date)

    Hi Bhone,

    You could create a custom field to record the Modified date of that specific field. For example, I would record the Phone Number field changed date on my Account entity. Please follow the below steps:

    1. Create a Date and Time field on the Account entity:

    0636.pastedimage1650592188886v1.png

    2. Create a workflow to automatically set this value which is triggered by the Phone Number changed.

    5164.pastedimage1650592311692v2.png

    Record fields changed:

    8244.pastedimage1650592344134v3.png

    Update Account step:

    1323.pastedimage1650592396280v4.png

    Finally, you could do some filter based on this value of field.

  • Bhone Profile Picture
    Bhone 15 on at
    RE: Is there a way to filter by the modified date of a specified field? (not the latest modified date)

    Thanks for the suggest, Steve.

    What I'd like to do is - there is a specific field and the user updates the field on Date A. Then some time later (Date B)  user updates another field of the related. I want to filter the view as per Date A. But system will show only the Date B if we use "Modified on".

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there a way to filter by the modified date of a specified field? (not the latest modified date)

    Hi Bhone,

    Do you want to filter this in a new view? If so, you could click 'Advanced Find' button to do this:

    pastedimage1650531697429v1.png

    And then new a view, filter your records by the modified date is ok(I used system field as a sample. In your case, you need select your own field.) :

    pastedimage1650531805227v2.png

    If no, please share more details of which you want to achieve.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,336 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans