Please assist in extracting latest date from tab delimited file.
I get this file weekly when system are polled by agent.
This agent just adds the date to current field 'SMS_R_System.Agent Time' though not consistent.
would like to extract the latest date from this field as mentioned in desired_result tab.
Attached is the file for current data and result_data
I am importing this file in Access.
conversion formula can be in excel or during import.