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.