Max Date but display another column

Hello, i need to display the max date on the page, but I need to display a text field form the date table that relates to the max date.

for example max date from the filter set to 30/01/2024. i have calculated to column to show this in ordinal format of 30th January 2024.

i cannot apply max to the ordinal column as it is a text field.