How to get list of all months and years between two dates (start date and end date) in Power automate?

[johnokeeffe]

Hi @Sampada30 ,

There was a similar question asked recently: Solved: Calculate months between two dates!!! - Power Platform Community (microsoft.com)

This should be a good starting point for you.

[Sampada30]

Hi John, 

Thanks for the reply.

But I am looking for a solution that actually gives me a list (array) that contains all the months and year falling between two dates.

For ex: if start date is 29-10-2022 and end date is 18-02-2023 I want to generate an array

[October-2022,November-2022,December-2022,January-2023,February-2023]

Any suggestion?

[johnokeeffe · Accepted solution]

Hi @Sampada30 ,

Sorry for the delay getting back to you.

I have a possible solution for you here that should get you what your looking for:

What I did was first get the start and end of each of the months as you are looking for the inclusive months value.

Then I just converted it to ticks and divided that to get the count of days. Once I had the days I needed to divide that by the average numbers of days a month to get the month count. I rounded this up quickly using the number function.

Once you have the number of months its time to create a while loop that loops until it is equal to the number of months from above.

Inside of the loop we just add the numbers of months to the start date and this will then give us a date in each of the months.

From here we just need to concatenate that value to create what you are looking for using the format datetime functions

Hope the above is the solution you are looking for?

Here is the flow zipped up so you can import to help you save time recreating this: https://github.com/john-o-keeffe/Power-Automate-Forum/blob/main/Howtogetlistofallmonthsandyearsbetwe...

[Sampada30]

Hi @johnokeeffe , thanks for the solution. 

As I didnt get any reply on time, I worked and did something similar to your solution to get the list of months and year and it worked. 

Anyway I am accepting your answer as solution since it is similar to my solution.

Thanks again 🙂.