How to loop date type into?

[Jackson_Hew (JH)]

I have a problem in continuing the activity flow in the image.

I wish to type into the first range of dates and download the report,
Criteria: every 90 days/3 months

(First range)
(Type Into) EndDate: 2024-01-09 ~ StartDate: Today ← 90 days

(second range)
(Type Into) EndDate: 2023-10-01 ~ StartDate: 2023-12-31 ← 90 days using the above’s EndDate minus 1 day

(third range)…and so on

Need to loop 3 times or iteration a total of 360/365 days from today

I have used the Modify Dates for the first range but i do not know how to throw it into the loop.

[avejr748 (Ave Salvante Jr)]

Here you go, just modify to suit your use case but this generally will serve your purpose:

Main.xaml (8.0 KB)

[Jackson_Hew (JH)]

Hi @avejr748 ,

It seems the document is invalid when I tried to open your .xaml file. Are you able to zip the entire folder and upload here instead?

[avejr748 (Ave Salvante Jr)]

Here you go
Date_Looper.zip (2.7 KB)

[Jackson_Hew (JH)]

Thanks!

It works greatly

[avejr748 (Ave Salvante Jr)]

You’re welcome. Glad that it gave you the idea. For some reason I have uploaded an earlier version. Here is the final version I get the output screenshot from
Date_Looper2.zip (2.6 KB)

[Jackson_Hew (JH)]

Oh yeah, I was about to ask since it kept the starting date as today while the end date is corect.

Thanks for the update!