Obtaining Overlapping Dates

So here’s a question

Say I have a daterange A: 1 2 3 4
And a daterange B : 3 4 5 6

Now using the “overlaps” function on A and B I get the value as “Yes” (since 3 and 4 overlap)

How do I get the list of dates that overlaps? (I want to obtain 3 and 4 in a Repeating Group called Overlapped Dates)

I have an idea of how to do this using multiple searches but I am sure there’s a much simpler solution I am missing!

This topic was automatically closed after 70 days. New replies are no longer allowed.