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:
If there is an entry in the table with the below details
C001 20142 01/01/2010 01/01/2011
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.