Lisa, (or anyone)
We have Kinetic Calendar hooked up to drive ITSM 7 - on call. This
type of problem could be eliminated as you would graphically see what
is covered what is not in a calendar -- and schedule people accordingly.
Would you be interested in seeing a demo on how to use Kinetic
Calendar to drive on-call schedules in a graphical way?
-John
--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
[email protected]
On Apr 3, 2009, at 1:11 PM, Kemes, Lisa wrote:
**
I have a record with a Start Date field of: 4/12/2009 12:00:00 AM and
an End Date field of: 4/30/2009 12:00:00 AM.
If someone were to create another record with a Start Date of:
4/1/2009 12:00:00 AM and an End Date field of 4/15/2009 12:00:00 AM, I
want it to error because this would "overwrite" (not really) the other
record.
This is for my On Call system. Therefore, if these 2 records are
allowed to exist, you would have more than one person on call (as a
primary) for the same dates (4/12, 4/13, 4/14 and 4/15).
Hope this makes sense!
I actually have these records on a table and I would like to walk
through the table to make sure the records with the Start Date field:
4/1 and End Date field: 4/15 does not get created.
AR System 7.0
Oracle 10g
Windows 2003 Server
Lisa Kemes
AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[email protected]
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
