1 2 Previous Next 24 Replies Latest reply on Nov 22, 2013 10:57 AM by ayescas

    Finding Overlapping Records:  Date, Time and Name

    ayescas

      Hello and thank you in advance,

       

      I need to figure out how to catch overlapping records. We can’t have the same person at two locations on the same day and time. How do I set up the relationships if I have the following fields:

       

      Meeting_Date

      Start_Time

      End_Time

      Employee

       

      How to can I create a calculation that would equal “Overlap” if someone is booked on the same date and time range ?

       

       

      Thank you.

       

      Alex Yescas

        1 2 Previous Next