How to get one record from list with condition of Date Descending

Hi Mark,

Please find your expected result 

public class Employee
    {
        public int EmpID { get; set; }
        public string FName { get; set; }
        public string LName { get; set; }
    }

    public class EmployeeDetail
    {
        public int Id { get; set; }
        public int EmpID { get; set; }
        public string Department { get; set; }
        public int Salary { get; set; }
        public string VisitDate { get; set; }

    }

List employees = new List();
            employees.Add(new Employee() { EmpID = 1, FName = "New", LName = "OLD" });
            employees.Add(new Employee() { EmpID = 2, FName = "FOG", LName = "HOP" });

            List employeesDetails = new List();
            employeesDetails.Add(new EmployeeDetail() { Id = 1, EmpID = 1, Department = "HR", Salary = 1200, VisitDate = "05/05/2021" });
            employeesDetails.Add(new EmployeeDetail() { Id = 2, EmpID = 2, Department = "HR", Salary = 1300, VisitDate = "08/08/2022" });
            employeesDetails.Add(new EmployeeDetail() { Id = 3, EmpID = 3, Department = "ICT", Salary = 1400, VisitDate = "01/01/2022" });

            var result = (from ed in employeesDetails
                          join e in employees on ed.EmpID equals e.EmpID
                          orderby ed.VisitDate descending
                          where ed.Department == "HR"
                          select new
                          {
                              Name = e.FName + "" + e.LName,
                              Department = ed.Department,
                              Salary = ed.Salary,
                              VisitDate = ed.VisitDate
                          }).FirstOrDefault();