Hi ,
I am trying to retrieve the contact type column data of a patient based on the recent date as shown below.
for instance
contacttype Datefrom
contact 1. 24/03/2020
contact 2. 20/05/2021
i need to retrieve the second contact2 based on the recent date.
i tried like below but not working .
Case max(datefrom) >0 then contacttype
End as contacttype
Can anyone please tell me why this is not working.Any other options?
Thanks
jude