Hi All,
I am trying to find all Payees who have overlapping dates. It would look something like this:
PayeeID: 3245
1/1/2011 - 5/1/2014
4/1/2013 - 4/1/2014
4/2/2014 - 9/1/2014
In this example, 5/1/2014 is incorrect and should be 3/31/2013.
My SQL is as follows, but isn't returning anyone.
SELECT EffectivePayee1.PayeeID
FROM EffectivePayee1
WHERE (((EffectivePayee1.Start_Date)>[EffectivePayee1].[End_Date] And (EffectivePayee1.Start_Date)<[EffectivePayee1].[End_Date]))
Thoughts?