I have a table that has multiple date fields. I need to compare three of the date fields and return the most recent date. Here is a simplified example of my Main table (tblMain):
LName
FName
Date1
Date2
Date3
How can I find the most recent date between Date1, Date2 and Date3? I will also need to retrieve the related data such as LName and FName along with the most recent date for each record in the table.
Thanks for your help!
LName
FName
Date1
Date2
Date3
How can I find the most recent date between Date1, Date2 and Date3? I will also need to retrieve the related data such as LName and FName along with the most recent date for each record in the table.
Thanks for your help!