Hi, as comments\work_notes are stored in the sys_journal field table as separate entries I suspect you would need to either create field(s) on your task table to track updates to the journal entries, create metrics for each journal update to track this requirement or create a separate reporting table to capture appropriate data, either in real time or via a schedule job.
Perhaps a choice list on your task table that is updated by an after BR on sys_journal_field,
but I would first assess the impact as the script would need to run on every journal update for a sctask record and this type of requirement can often result in performance degradation as you eventually end up with many unnecessary scripts running on core system tables.
From a business perspective the work_notes and comments fields deliver completely separate functions and are populated for different reasons, so I see no business value in identifying that work_notes and comments were updated on task X.. the same day.. Y days ago, if no update has been made to the task since.
Rather I would recommend that you consider using OLA/SLA to track updates for the 2 fields separately.
