Hi,
So I currently have a query that looks at a table with appointment requests against a another table Appointment Booked and then another Table Appointments completed.
What I need to do is only show appointment requests if the Appointment Booked and Appointment completed dates are greater than the Appointment Request date
So if an appointment was requested on 01.05.2020 but the Appointment Booked has an appointment date for 14.04.2020 and Appointment completed 15.04.2020 this would show records as it was created after the other dates?
So I currently have a query that looks at a table with appointment requests against a another table Appointment Booked and then another Table Appointments completed.
What I need to do is only show appointment requests if the Appointment Booked and Appointment completed dates are greater than the Appointment Request date
So if an appointment was requested on 01.05.2020 but the Appointment Booked has an appointment date for 14.04.2020 and Appointment completed 15.04.2020 this would show records as it was created after the other dates?