Search Criteria – To get the data that were edited or created within 24 hours

Saved search formula to fetch the record data that were created or edited within the last 24 hours.

Based on the updates that appeared in the “System notes,” the data for this saved search is fetched.

provide these criteria in the ‘Formula text‘

CASE WHEN ({systemnotes.date}>= {today}-1 ) THEN ‘SYS_NOTE’ WHEN ({datecreated}>= {today}-1 ) THEN ‘CREATE’ ELSE ‘NO_ACTION’ END

formula text: Is not NO_ACTION.