Calculate days since last visit is not pulling from the last appointment date
The goal is to create a report displaying all patients with no contact based on a 3,6,9,12,18,24 month time period. This will help Mgt know how many patients are still marked active in the system though but have had no contact in a set time frame. The 90 day mark is a sign the patient can be marked inactive.
I created two new columns based off the Appointment Date field. One counts the days from the appointment till today and the second puts the appointment into a bucket.
My issue is that based on settings I never get to see ONLY the patients LAST appointment and how many months ago it was.