Hi Lisa,
I think you need to create a filter with a Set Field action that will
check the condtion hereafter, and a second one that will raise an
error if the first filter found a matching record.
Let's assume that your form is called Sample
You create a display-only field on that form called zTmpEntryID
You create a first filter on submit and on modify. The Run If is
empty. It contains one Set Field action
From: Sample
Set If: ('Start Date' <= $Start Date$ AND 'End Date' > $Start Date$)
OR ('Start Date' < $End Date$ AND 'End Date' >= $End Date$)
If No Match => Set Field To Null
If Multiple Match => Use First Matching
zTmpEntryID <- $1$
The second filter just displays an error message in case of
zTmpEntryID is not null.
Hope this helps,
Jean-Louis Halleux
Remedy Expert & Developer
ARSmarts sa
www.arsmarts.com
On 03 Apr 2009, at 20:11, 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"
