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

[Kausar]

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.

[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

[ShankerV · Accepted solution]

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

[Kausar]

Hi @ShankerV,

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

[ShankerV]

Hi @Kausar 

Glad to help!!!