ayescas

Finding Overlapping Records:  Date, Time and Name

Discussion created by ayescas on Nov 21, 2013
Latest reply on Nov 22, 2013 by 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

Attachments

Outcomes