Dynamic Input to pull data for current month only each day

[gam2086]

Hello Community,

Need help with dynamic input to pull data from start of the month to end of the month. Workflow will run daily. 

Example: Today 8/14/2023

 workflow should pull data : 08/01/2023 to 08/13/2023

also, Skip weekend.

Attached is dynamic input for month and try to did for daily, but not successful.

Thanks in advance

[alexnajm]

I am not sure I understand where these parameters are going, but if you want all dates (excluding weekends) in between yesterday and the first of the month:

1) calculate yesterday and first of month (Formula)

2) generate all days within each month (Generate Rows)

3) use logic to exclude weekends (Filter)