Decrementing the date field by 1 for 31 days and passing it to the workflow

[Idyllic_Data_Geek]

I have a requirement to execute the daily workflow for last month. it should do it iteratively for each day and aggregate the data in the final output file. It should pass one date and let the workflow execute and then reduce the date by 1 and repeat. Can I use any calculation instead of using a macro?

Thanks in advance for your valuable time!

[atcodedog05]

Hi @Idyllic_Data_Geek 

Here is how you can do it.

Workflow:

Hope this helps : )

[Idyllic_Data_Geek]

Thank you. Why are you using generate rows? The calc looks slightly complicated for my simple req. datetimetoday() should be used to give me previous month name and year.

[atcodedog05 · Accepted solution]

Hi @Idyllic_Data_Geek 

You are right use formula like below

DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,"months"),"%b-%y")

Workflow:

Hope this helps : )