Task: Build a form (or forms) to hold a list of users and the hours they start and end their work day (24 hour clock): ie 08:00-17:00 or 22:00-0600. Do not want to store times for each day of the week. For each ticket submitted search the list of users and find one that is available at the time the ticket is being created. This means matching the current time between the start and end times for each user.
Logically this sounded simple enough but the problem I'm having is when a ticket is submitted at say 3am. I have qualitication that is checking to see if the current time is between the start and end time for a user. So, if it is 16:00 and the user works 08:00 to 17:00 they are included. However, if is 02:00 and the users schedule spans two days, 22:00 one day till 06:00 the next, the qualification fails. I feel there is a simple solution to this issue but cannot sem to come up with it. I though of just creating mutiple entries for certain users whose schedule spans two days, one for 22:00 to 23:59 and one for 00:00 - 06:00, but was hoping someone had another thought. Thank you _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
