General information
Category:
Coding, syntax & commands
Title:
Calculating a Schedule Conflict
Hi All,
Trying not to reinvent a wheel here. I am creating an app for a child learning center. Each child can be entered into a several programs that the center offers. Each program has a schedule, i.e. PT1 meets M,W,F from 10:00 to 10:45, OT2 meets M to F 9:30 to 10:00. I need to figure out if there is a conflict between the programs that are scheduled for a child. I have a child table and a program table. The program table has logical values for each day of the week for when it meets and a from and to time that it meets. The number of programs a child is assigned to varies for each kid. A cross table contains a child id and program id. Any ideas of how to efficiently code whether there is a conflict in a childs schedule? I would need to know whether there is a confilct as well as which two or more programs conflict. Ideally it would be best to account for possibilites of any start and end time, i.e I don't want to make an assumption the start and end times are in 15 or 30 minute increments. Any ideas of to go about this?
Thanks in advance.
Peter
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only