Most recent Status created date

Most recent Status created date

Hello,

I need to create a report where i only have the most recent Status (according to the date) with the the comments etc. Below is the an example of the data I have:

Candidate Name
Current Job title
Client
Postilng title
 New status
Created dated
Comments
John Smoth
CMO
 Nobody
xxx
Shortlisted
2020-06-22 12:14:42
good candidate
John Smoth
CMO
Nobody
xx
Interview
2020-06-26 11:20:16
move through process
John Smoth
CMO
Nobody
xx
On hold
2020-07-03 14:36:16
Hiring freeze

I need to have a report with just so the
John Smoth
CMO
Nobody
xx
On hold
2020-07-03 14:36:16
Hiring freeze

 I have tried to use SQL with 'max' "created date", but I can't seem to get it work. I'm hoping someone can help!
thanks in advance