I'm real sorry to be posting here so please go easy on me. I'm under a deadline and I've already spent a couple hours trying to figure this out myself.
I would like a list of all Patients who have not seen their doctor since xyz date.
Relevant Tables and Fields
DateOfService (Timestamp field)
(One PATIENT to many VISIT)
I've tried to set up a Portal filtering with a MAX calculation (MAX VISIT::DateOfService = 4/17/2017) but the portal for every visit appears blank even though there are visits with a Date of Service less than 4/17/2017).
I'm sure it's something really simple that I don't understand so I'm thankful in advance for the help.