Good Afternoon from the East Coast. I have a quest...
# general
j
Good Afternoon from the East Coast. I have a questions for a saved search filter on the date last modified. Is anyone aware of the ability to filter a saved search by the time the record was modified? Lets say you're just looking for records that have been modified since 1:00PM? Is anyone familiar with this?
s
Is this something you are looking at as a one off or something to do consistently? You do use relative filters to look for things modified since 105 minutes ago to fit your need now
j
A fairly regular need. what field would you use for the criteria?
s
Last modified date, calculate between now and whenever, and use relative filter
j
For an item record for instance. are you using a formula field?
s
No, there is a field called
Last Modified
, and then in the date picker, select relative instead
r
A longer approach but might worth checking out if you have some specific fields in mind. system notes: type is change System notes: date is on or after x days ago. If you only want the modified records and not the one that are newly created. Add two more filters. System notes: new value is not empty System notes: old value is not empty If further need to search for change in a specific field. You can use system notes: field and select the fields.