Hi Lisa,
You could look at taking the on call end date of person A and subtracting it from the on call start date of person B. If the end result is say greater than an hour, you could advise somebody. In fact you could make this part of the process when entering the dates so that an individual is made aware that their on call is starting at an unacceptable time after their colleagues finishes. You could make it a warning or an error depending on the severity of it. I would probably give them an overriding option which shows that they are aware of the gap and then email the groups manager in the background. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: 20 May 2009 17:33 To: [email protected] Subject: Calculate Gaps in Schedule ** Is there an easy way I can notify a user if there are gaps in his on call schedule? If person A from Group A is on call from May 1st 12:00am to May 5th 12:00am And Person B from Group A is on call from May 7th 12:00am to May 12th 12:00am I'd like to create some sort of calculation to capture the "gaps" for a user, to warn them that nobody is on call from May 5th at 12:01am to May 6th at 11:59pm. It might not even have to be that detailed, maybe just a "yes" or "no" that there are gaps and I can just notify the admin and they would have to check it themselves….. The data is on a table so I could do a loop and the Date Fields are Date/Time Fields….. ARS 7.01 Patch 3 Windows 2003 Oracle 10i Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [email protected] _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.329 / Virus Database: 270.12.34/2121 - Release Date: 05/18/09 17:55:00 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
<<image001.gif>>
