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

Find a Record a record with Overlap Period


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


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.