I have two tables.
Table 1: Client
Table 2: Appointments
Each appointment is tied to a client. I’m looking to see how many days from the client’s last appointment.
E.g. the client’s has 3 appointments however his last appointment was 1/1/2020 then the cell would display ‘14’ since that was 14 days ago.