Max dates

[anneb_87]

Hi Experts!

I need to get the maximum DAY dates of the following clients
Client Max day dates
A 15
B
C


Here is the source data:
CLIENT CATEGORY DATE RECEIVED
A MEDICAL 7-NOV-19
A DENTAL 15-NOV-19
A VISION 15-NOV-19
B MEDICAL 15-NOV-19

 

[anneb_87]

It works! Hopefully they won't give me a different source data.. THANK YOU SO MUCH!!!