Two dates range comparison - ClickUp Make

Questions & Answers
1

Hello,

Is there any way that I can detect if there is common days between two date range?

For example, if we have the first task - start date: 7/10/2023 → due date: 7/15/2023,

and the second task - start date: 7/9/2023 → due date: 7/16/2023.

Thanks

2

Hi @Judy_Dibsi

To calculate the number of days between two dates, utilize this formula: {{round((7.End Date - 7.Start Date ) / 1000 / 60 / 60 / 24)}}.

Please ensure that you have employed date type data for both the End Date and Start Date.

image

Thanks & Regards

MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Hi @Msquare_Automation,

I don’t need the number of days, I want to detect if there is common days between two dates.

For the example, 7/10/2023, 7/11/2023, 7/12/2023, 7/13/2023, 7/14/2023 are the common days between the two dates I wrote before.

if we have the first task - start date: 7/10/2023 → due date: 7/15/2023,

and the second task - start date: 7/9/2023 → due date: 7/16/2023.

Thank you

4

Hi @Judy_Dibsi

To solve your issue, please follow the below steps

  1. Compare starting date and choose largest date.
  2. Compare ending date and choose lowest date.
  3. Put the collected date difference into the repeater module add the the repeater value with collected start date and collect all with text aggregator. If you want to make array with the result please use split with the text data

Thanks & Regards

MSquare Support
Visit us here
Youtube Channel

2 Likes