Hi Frank, I had a similar issue once and created fields for 'Shift', with values like 'Shift 1', 'Shift 2'etc. (including weekends) on the User form (or you could use a work schedule form) and had workflow to check which Shift range the timestamp fell into and then looked up active users (Assignees) on that shift. The WEEKDAY function is helpful in determining the day of the week.
Hope this helps, Sylvia Holy -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Wednesday, January 03, 2007 12:59 PM To: [email protected] Subject: Time Scheduling 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
