Thank you very much for your response. It is just that in some cases, the 'overlap' column is the difference between have.start_dt and have2.end_t, or between have2.start_dt and have.end_dt, or have.start_dt and have.end_dt or have2.start_dt and have2.end_dt. To illustrate: overlap is the difference between dates a and b a. _______ b. c.______________d. or overlap is the difference between dates c and d a.__________________b. c.________d. or overlap is the difference between dates c and b a.____________b. c._______________d. or overlap is the difference between dates a and d a.___________b. c.____________d. I was wondering if there is a way to output the two dates that were used to compute the overlapping days. Thank you very much for any help you could give!
... View more