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

(0) Share

Report

Posted on by Bhone

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Hi Bhone,

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

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.) :

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

Was this reply helpful? Yes No
Bhone 15 on at

Like (0)

Report

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".

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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:

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

Record fields changed:

Update Account step:

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

Was this reply helpful? Yes No
Bhone 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No