Hi all, I have a date field and I want to filter by the modified date which updated the date field by the user.
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.
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.
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".
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156