Skip to Content
0
Former Member
Jul 29, 2016 at 02:19 PM

need to process if patient not been here for past 6 months.

23 Views

I have a coulmn appointment_date. I need to write a report that will show patients who have not been to our medical facility for 6 months +

I don't do any record select.

I have one group, for Patient_ID. THen I have a formula for the appointment date:

if Date({DDB_APPT_BASE.APPTDATE}) < date(2016,01,28) then

Date({DDB_APPT_BASE.APPTDATE})

then I have a formula Maximum({@Appt_date},{DDB_APPT_BASE.PATID}) which should be getting me then the last appointment date 6 months and beyond but its not doing I am getting last week in the results.