Find a date range or part of it in another date range

I am new to Alteryx and am stuck on this. How do I check if a date range or part of it fall within another date range? All the discussions I have seen are trying to find a single date within a date range.

Below example is my problem - I am trying to find which date range in 2022 falls within the input date range.

Thanks.

Date Time

Accepted answers

ShankerV

Hi @Kausar

Added 3 tools at the end to match your output format.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Find a date range or part of it in another date range.yxmd

All comments

ShankerV

Hi @Kausar

The solution can be derived with the following steps.

1. Change the dates to Alteryx format

2. Generate rows for all days in between

3. Filter if its range between year 2022

4. Then format to display the result via Summarize tool

ShankerV

Hi @Kausar

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Find a date range or part of it in another date range.yxmd

ShankerV

Hi @Kausar

Added 3 tools at the end to match your output format.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Find a date range or part of it in another date range.yxmd

Kausar

Hi @ShankerV,

Many thanks for quickly replying on this! It achieved my objective.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703