Could somebody please help me with running a report on patients seen within the last 18 months? By all clinicians, between 09/10/2019 - 09/04/2021.
To create a query to find patients that have visited between 09/10/2019 - 09/04/2021.
This will find all patients whose last completed appointment was between the 2 dates.
If you want to filter out patients who have a pending appointment in the future then add the following between lines 11 & 12.
I hope this resolves your query, if not, then do please get back to us.