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

Take only the Latest Record Date from Custom Date Field

Accepted answer
edited May 22, 2019 9:37AM in Reporting & Analytics for B2C Service 3 comments


Take only the Latest Record Date from Custom Date Field


We have a custom object to store Transactional data where we have created a field called "travel Start Date".

I need to create a report with Customer Name, Count of Ticket Numbers, Count of Ticket amount and Latest Travel Date. When I create the report, I get like below with repetitive date values in Travel Start Date 

"Full Name" "Ticket Number" "Ticket Amount" "Travel Start Date"
"Jamal Ahmed" 1 10 03/05/2019 11:50 AM
"Jamal Ahmed" 1 15 03/05/2019 02:05 PM
"Jamal Ahmed" 1 35 06/05/2019 04:05 PM
"Jamal Ahmed" 1 10 07/05/2019 03:05 AM
Expected result as below
"Jamal Ahmed" 1 70 07/05/2019 11:50 AM



Howdy, Stranger!

Log In

To view full details, sign in.


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