Select Most Recent Client Record Given Date Values Selected

Hello everyone,   I've been having trouble finding a solution for this problem, having not been able to replicate solutions posted to similar problems featured on the forums.   In the link below,...