How to split the dates with given Range

Help Studio
, ,
1

Hi,

Dates are in MM/dd/yyyy format
Start Date: 05/25/2025
End Date : 08/31/2025.
Need to split the date based on given input like 15 days/1 month and generate start and end for each interval like below.

Output:(split based on month)
From Date:05/25/2025 To date:05/31/2025
From Date:06/01/2025 To date:06/30/2025
From Date:07/01/2025 To date:07/31/2025
From Date:08/01/2025 To date:08/31/2025

Output:(split based on 15days gap)
From Date:05/25/2025 To date:06/09/2025
From Date:06/10/2025 To date:06/25/2025
From Date:06/26/2025 To date:07/11/2025
From Date:07/12/2025 To date:07/27/2025
From Date:07/28/2025 To date:08/12/2025
From Date:08/13/2025 To date:08/28/2025
From Date:08/29/2025 To 08/31/2025

TIA

2

You can try using this LINQ filter to get the necessary data between specified dates.

A screenshot of a UiPath workflow assigning a filtered DataTable (dtFilteredReport) based on a date range to a variable within a sequence. (Captioned by AI)
A screenshot of a UiPath workflow assigning a filtered DataTable (dtFilteredReport) based on a date range to a variable within a sequence. (Captioned by AI)925×308 12.8 KB

dtReport.AsEnumerable.Where(Function(drRow) drRow.Field(Of DateTime)("Date") >= dtmStartDate AndAlso drRow.Field(Of DateTime)("Date") <= dtmEndDate).CopyToDataTable

Let me know if you have further questions.
I hope this helps.

Cheers!

3

@Manaswini_UI

this generate a list of tuple…that is each list item containign two dates one start and one end

The image shows a list of tuples in a programming environment, each containing two identical DateTime values. (Captioned by AI)
The image shows a list of tuples in a programming environment, each containing two identical DateTime values. (Captioned by AI)976×123 3.57 KB

Enumerable.Range(0, Integer.MaxValue).
                                   Select(Function(i) startDate.AddDays(i*15)).
                                   TakeWhile(Function(d) d <= endDate).
                                   Select(Function(d) New Tuple(Of DateTime, DateTime)(d, If(d.AddDays(15) > endDate, endDate, d.AddDays(15)))).
                                   ToList()

this is for 15 days if you need month use 30 or addmonths inplace of adddays

Enumerable.Range(0, Integer.MaxValue).
                                   Select(Function(i) startDate.AddMonths(i)).
                                   TakeWhile(Function(d) d <= endDate).
                                   Select(Function(d) New Tuple(Of DateTime, DateTime)(d, If(d.AddMonths(1) > endDate, endDate, d.AddMonths(1)))).
                                   ToList()

usage

A software interface displaying an "Assign" activity that assigns a list of integers generated by the Enumerable.Range method, followed by a "Build Data Table" activity alongside a pop-up showing a LINQ query for generating tuples of date ranges. (Captioned by AI)
A software interface displaying an "Assign" activity that assigns a list of integers generated by the Enumerable.Range method, followed by a "Build Data Table" activity alongside a pop-up showing a LINQ query for generating tuples of date ranges. (Captioned by AI)973×247 13 KB

The image shows a variable management screen with three variables defined: "startdate" and "enddate," both of type DateTime, and "listup," which is a List of Tuples containing DateTime objects. (Captioned by AI)
The image shows a variable management screen with three variables defined: "startdate" and "enddate," both of type DateTime, and "listup," which is a List of Tuples containing DateTime objects. (Captioned by AI)1375×163 13.9 KB

cheers

4

List<Tuple<DateTime, DateTime>>(7) { (05/25/2024 00:00:00, 06/24/2024 00:00:00), (06/09/2024 00:00:00, 07/09/2024 00:00:00), (06/24/2024 00:00:00, 07/24/2024 00:00:00), (07/09/2024 00:00:00, 08/08/2024 00:00:00), (07/24/2024 00:00:00, 08/23/2024 00:00:00), (08/08/2024 00:00:00, 09/07/2024 00:00:00), (08/23/2024 00:00:00, 08/31/2024 00:00:00) }
To date column showing incorrect value
05/25/2024+15 days=06/09/2024

5

@Manaswini_UI

Edited the formula above instead of d.Adddays(30) use d.adddays(15)

Use thw edited formula from above comment

Cheers

6

Thankyou its working but can we do small change in formula to get the the values like below
From date in 2nd row starts from 06/10/2025 (06/09/2024 covered in first row Todate) like wise other dates also should change like below
Output:
From Date:05/25/2025 To date:06/09/2025
From Date:06/10/2025 To date:06/25/2025
From Date:06/26/2025 To date:07/11/2025
From Date:07/12/2025 To date:07/27/2025
From Date:07/28/2025 To date:08/12/2025
From Date:08/13/2025 To date:08/28/2025
From Date:08/29/2025 To 08/31/2025

if possible, Can you please check and update the query

7

@Manaswini_UI

here is a small modified code

Enumerable.Range(0, Integer.MaxValue).
                                   Select(Function(i) startDate.AddDays(i*16)).
                                   TakeWhile(Function(d) d <= endDate).
                                   Select(Function(d) New Tuple(Of DateTime, DateTime)(d, If(d.AddDays(15) > endDate, endDate, d.AddDays(15)))).
                                   ToList()

cheers

8

Thankyou, its working

1 Like
9

can we get the dates like below start date and end date of each month from given date range

05/25/2024 00:00:00, 05/31/2024 00:00:00),
(06/01/2024 00:00:00, 06/30/2024 00:00:00),
(07/01/2024 00:00:00, 07/31/2024 00:00:00),
(08/01/2024 00:00:00, 08/31/2024 00:00:00)

10

can we split the dates month wise from given start and end date like below

05/25/2024 00:00:00, 05/31/2024 00:00:00),
(06/01/2024 00:00:00, 06/30/2024 00:00:00),
(07/01/2024 00:00:00, 07/31/2024 00:00:00),
(08/01/2024 00:00:00, 08/31/2024 00:00:0

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.