Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Take only the Latest Record Date from Custom Date Field — Cloud Customer Connect
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
14
Views
3
Comments
edited May 22, 2019 9:37AM in Reporting & Analytics for B2C Service 3 comments

Summary

Take only the Latest Record Date from Custom Date Field

Content

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

Version

19A

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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