Filtering data on most recent date
Content
I am creating a report using a custom object linked to a contact. I want to display only the most recent date that is contained in the date column/custom object field for the person. It might make more sense looking at my data:
Contact ID | Park Visited | Date Visited |
456789 | Hyde | 12/05/2014 |
456789 | Smith | 10/10/2013 |
456789 | Black | 05/05/2015 |
So all 3 entries belong to the 1 contact, but in my report I only want to see Black Park and the date of 05/05/2015 for Date Visited.
I am not really sure about using functions in expressions etc, so would love some assistance please!
Thanks in advance!
Version
Tagged:
0