Matching the date in between both dates

[SH_94]

Dear community, 

I would like to ask how can we perform the following step:

1. Checking if the date in Data B if it is in between any both date of Data A

2. If it is between any both of the dates, please show the result as per Output A

3. If the date in Data B is not between of any date in Data A, please show in Output B

In real data , it have a lot of date and we need to check if it is between both date in Data A.

May i know how can we do it in this case?

Thank you.

[Jonathan-Sherman]

Hi @SH_94,

If we generate the rows required we can join on the OJD and date fields:

Output A:

Output B:

The results from the inner join will get your output A (that match) and the right will give you your output B (that don't match)

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[SH_94]

Dear @Jonathan-Sherman ,

Many thanks for the prompt response.

May i know how to change the formula from less than to less than or equal to Closing date?

thank you.

[Jonathan-Sherman]

Hi @SH_94,

You'll want to change the Condition Expression in the Generate Rows tool to be Date <= [Closing Date]

Kind regards,

Jonathan

[allwynthomas24 · Accepted solution]

Hey @SH_94,

Please check the attached workflow and confirm whether it matches your current requirements.

Thanks & Regards,

Allwyn

Spoiler