Saved search operation to find the latest data based on the date

To find the latest data of a field for standard and custom records, use the following formula in a saved search

MAX({field_id}) KEEP(DENSE_RANK LAST ORDER BY {date field_id} )

Leave a comment

Your email address will not be published. Required fields are marked *