AnsweredAssumed Answered

Counting Patients who have not had a visit since xyz date?

Question asked by pcuezze on Aug 18, 2017
Latest reply on Aug 18, 2017 by pcuezze

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

 

PATIENT

PatientID_pk

PatientName

 

VISIT

PatientID_fk

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. 

Outcomes