I’m looking for a formula that can read through multiple records and identify the earliest (minimum) future schedule appointment date in a specific department or indicate there is no future appointment.
- Appointment Date > Today
- Appointment Status = Scheduled
- Department = Dental
I have tried a formula that evaluates each line and returns either totext({APPT.APPT_TIME}) or "00 No future appt" then grouping and sorting to return the earliest future appointment but this is very clunky and not always returning the correct values.
Is there a better way to do this?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.