Hi Lisa,
I would suggest you want to check if either the start date or end date falls within the date range used. Thus to do this you would need the following. (“Start date of record being submitted” => “Start date of record submitted” AND “Start date of record being submitted” =< “End date of record submitted”) OR (“End date of record being submitted” => “Start date of record submitted” AND “End date of record being submitted” =< “End date of record submitted”) This would tell you if either the start date or end date fall within the range already allocated. Brian Bishop Goldstag Consultants Ltd tel: 07973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: 03 April 2009 19:12 To: [email protected] Subject: FW: Am I making this more difficult than it is? ** 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___ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.283 / Virus Database: 270.11.40/2039 - Release Date: 04/03/09 06:19:00 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
<<image001.gif>>
