Skip to Content
0
Former Member
Aug 19, 2010 at 02:06 PM

Find a Record a record with Overlap Period

20 Views

Hi Experts,

I am developing a Module Pool Program to maintain the entries of a Z Table. My requirement is I should allow the User to create or Change the entry with Overlap Period. Below is Details.

Z Table Fields:

Company Code

Customer

Issue Date

Expiry Date

If there is an entry in the table with the below details

C001 20142 01/01/2010 01/01/2011

New Record

C001 20142 06/01/2010 12/31/2011

I should allow the user to create the second record as the record is having the Over Lap period . But he can create the record from 02/01/2011 to any date.

Please suggest how should be my SELECT statement.

Thanks in advance.

Regards,

Srinivas