Greetings wise ones!
I have a base to track family medical history which includes a Doctors table and a Dr Appointment table. All appointments in the Dr Appointment table are linked to a doctor in the Doctors table. This includes past appointments and upcoming scheduled ones. In the Doctors table I would like one field where the date of the next appointment is calculated and shown and one where the most recent appointment is calculated and shown. How do I write a formula/rollup that looks at only the past or only the future dates and chooses the last of the past or next of the future?
I’ve created fields calculating the appointment dates from TODAY if that helps.