Enum Dates between start and end date

[giuseppe.amaranto]

Howdy
Starting from a start date and an end date, how do I get a progressive variable for months and year?

Let me explain:
Start date 04-05-2023
End date 01-10-2025

I would need to get the list of months and years between them:
05-2023
06-2023
Etc
…
09-2025
10-2025

Many thanks

[samliew]

Welcome to the Make community!

You’ll need three modules for this.

1. Store Start/End Date variables in date type

2. Repeat number of months

Calculation: (Start - End) / months_in_milliseconds

3. Aggregate results in format you want (MM-YYYY)

If you want a separate bundle per month, you can either

• use a Text Parser “Match Pattern” module to split by newline (recommended to save ops), or
• replace the “Text aggregator” module with a “Compose a variable” or “Set variable”

Output

[giuseppe.amaranto]

Ohhh amazing!! You are a wizard!

[samliew]

No problem, glad I could help!