How to get dates in between two dates

Help Studio
, ,
1

Hi all,

I have these 2 dates 01/30/2021 and 10/30/2022
and I need to get every month in between. I´m able to get the months when its the same year, but I have probmes trying to get them when the year is different.

Thank you in advance

2

Hi @domingo.ruiz

Check out this video link

Regards
Gokul

3

which output datatype / representation of the month series is needed?

4

Thank you, thats helpfull.

What I need tho, its to get for example
01//30/2021
02/30/2021 and so on till
10/30/2022

Regards

5

“MM/dd/yyyy” datatime format

Thank you!

6

maybe you recheck your requirements as there is no 30th February existing.

7

sorry, its a typo

8

Hi @domingo.ruiz

Check out this XAML file

DateInterval.xaml (12.9 KB)

image

image

Regards
Gokul

9

In the While loop condition Update it please @domingo.ruiz

Instead of FromDate use Tempdate

image

10

Thats a good approach, but it doenst break the loop in my case, im trying to fix it

11

Check out this image ? @domingo.ruiz Need to change the Fromdate to Tempdate < ToDate

12

Yep I did. It should work, maybe i have my date in a wrong format

13

Okay @domingo.ruiz

If the query is solved Kindly close this topic by mark as solved. It will help for other too

Regards
Gokul

14

Thank you. It works!

15

Close this topic @domingo.ruiz By mark as solved

16

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