You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filtering data on most recent date

edited Feb 11, 2016 5:45AM in Reporting & Analytics for B2C Service 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!