Detecting overlapping appointments is a classic problem typically almost impossible to solve with previous native Quickbase but which should be very well suited using Formula Queries.
I do not have time right now to actually do a test but your formula looks very long to me. I think you just need to look for where the start date of the record you are on is before than the end date of the other records and the end date of the record you are on it is after the start date of the other records.
Can you give that concept a try and post your solution if it works?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
