If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to Identify Records with Overlapping Dates
I need to be able to systematically identify any instance where there are
overlapping date ranges in a data set. I need to pull records like those listed below out of a larger data set. I previously posted a question similar to this and was advised to pull the same table in a query, match on Member Number, and qualify that the product code from TableA did not match product code in TableA_1 where the Begin Date TableA was Term date TableA_1 and TableA_1 Begin Date TableA End Date. Which worked great for me finding overlapping records where the product was different, but now I also need to find them when the product is the same ProductCode MemberNumber Begin Date End Date PFFS 123456789A 20090101 20091231 PFFS 123456789A 20081201 29991231 Thanks for you help |
Thread Tools | |
Display Modes | |
|
|