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!

[Idyllic_Data_Geek]

working days in last month

[atcodedog05]

Hi @Idyllic_Data_Geek 

You can filter out weekends by using a filter like below.

DateTimeFormat([Dates List],"%a") not in ("Sat","Sun")

Workflow:

Hope this helps : )

[Idyllic_Data_Geek]

awesome 🙂 Now is there a way where I can identify current month based on today's date? then

1) identify the previous month

2) Identify all the week days(dates) in that month?

Thanks a bunch in advance

[atcodedog05]

Hi @Idyllic_Data_Geek 

Can you provide the expected output so that I can work towards it.

[Idyllic_Data_Geek]

If I run this workflow in September then I only want to account for working days in August. I do not want to include anything from September or July

[atcodedog05 · Accepted solution]

Hi @Idyllic_Data_Geek 

Here is how you can do it.

Workflow:

Hope this helps : )

[Idyllic_Data_Geek]

Thank you. I tool a slightly diff approach by calculating the month of today's date. Then I subtracted the number...changed the data type and set the logic/filter to be today_month - report_month = 1

[atcodedog05]

@Idyllic_Data_Geek 

Awesome!

Happy to help : )

Cheers and have a nice day!

[Idyllic_Data_Geek]

I have another question related to same workflow.  I used DateTimeFormat(DateTimeToday(),"%B") to get month of september. What is the easiest way of getting august by doing sept-1? TIA

[Idyllic_Data_Geek]

How can I use today's date to derive previous month name and year..sth like AUG-21