Generate Rows for End of Month

[bertal34]

What is an easy way to generate the next 12 dates in this sequence and add 12 rows?  2020-10-31, 2020-11-30, etc.

[Felipe_Ribeir0]

Hi @bertal34 

One way of doing this, just configure the start/end date properly

[bertal34]

Is there a way to limit to 12 months only, no matter what date is initialized?

[Emmanuel_G]

@bertal34 

Find in attachement the way of doing that.

[Felipe_Ribeir0 · Accepted solution]

Hi @bertal34 

There is, please check the new version (attached)

[binuacs]

@bertal34 One way of doing this

[bertal34]

@Felipe_Ribeir0 perfect, thank you!!

[Astro55]

@binuacs - Your Solution really helps with a use case I have! I'm trying to generate a row of dates, starting from the last day of the previous month to the next 14 months. 

I used your workflow as a starting point. I was able to tweak my Initialization Expression to start from the first date of the previous month. However, I'm struggling with tweaking your formula for the Condition Expression. The expression in your workflow above ends at '-12-31' because the OP wanted to limit the rows to 12 months.

Question: How do I amend the Condition Expression to list the next 14 months, instead of stopping at 12/31? 

Example:

If I run the workflow today (ie., 3/2/23) using the following conditions

• Initialization Expression: DateTimeAdd(DateTimeTrim(DateTimeToday(),'firstofmonth'),-1,'month')
• Condition Expression: Date <= toDate(toString(DateTimeYear(DateTimeToday()))+'-12-31')

This gives me dates from 2023-02-01 through 2023-12-01. However, this is just 11 months. How do I get it for 14 months, i..e, from 2023-02-01 through 2024-03-01. 

[Astro55]

@binuacs - I think I figured it out!

• Initialization Expression: DateTimeAdd(DateTimeTrim(DateTimeToday(),'firstofmonth'),-1,'month')
• Condition Expression: Date <= DateTimeAdd(DateTimeTrim(DateTimeToday(),'lastofmonth'),+12,'month')

If I run it today (i.e. 3/2/23), it gives me 14 dates, from 2023/02/01 through 2024/03/01!

I'm hoping this is correct. Is there a better way of doing it?

[binuacs]

@Astro55 Updated the workflow and attached