Use case is that we use custom tables to provide monthly updates using standard fields (ie Accomplishments, Whats Next, Risks, Issues). We want to be able to show the most recent entry on a dashboard report for senior leadership to view at any time. Right now the ability to filter on dates does not include the same as for the "Comments" field where you can select the most recent to show in a report.
I have a custom table in an Initiative record and need to be able to pull only the max effective dated row (newest entry) for a report. Cannot for the life of me figure out how to do this.