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:
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”
Ohhh amazing!! You are a wizard!
No problem, glad I could help!