I have a very long workflow and a filter tool present in that workflow has a condition like this [Date_0] >= "2022-01-01" AND [Date_0] = "2022-01-01" AND [Date_0] = "2022-01-01" AND [Date_0] = "2022-01-01" AND [Date_0] = "2023-01-01" AND [Date_0] = "2023-04-01" AND [Date_0] = "2023-01-01" AND [Date_0] = "2023-02-01" AND [Date_0] = "2023-03-01" AND [Date_0] = "2023-04-01" AND [Date_0] = "2023-04-01" AND [Date_0] = "2023-05-01" AND [Date_0] = "2023-06-01" AND [Date_0] = "2023-07-01" AND [Date_0] = "2023-08-01" AND [Date_0] = "2023-09-01" AND [Date_0] = "2023-10-01" AND [Date_0] = "2023-11-01" AND [Date_0] = "2023-04-01" AND [Date_0] <= "2023-12-31"

Automating Filter Tool having Date Range

I have a very long workflow and a filter tool present in that workflow has a condition like this

[Date_0] >= "2022-01-01" AND [Date_0] <= "2023-03-31"

Currently i am executing the workflow 17 to 18 times after editing filter tool as per the conditions given belwo

I want to automate this workflow so that the conditions given below are present in excel and workflow runs automatically 17 to 18 times

when clicked once

[[Date_0] >= "2022-01-01" AND [Date_0] <= "2022-12-31"
[Date_0] >= "2022-01-01" AND [Date_0] <= "2022-07-31"
[Date_0] >= "2022-01-01" AND [Date_0] <= "2022-08-31"
[Date_0] >= "2023-01-01" AND [Date_0] <= "2023-03-31"
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-06-30"
[Date_0] >= "2023-01-01" AND [Date_0] <= "2023-01-31"
[Date_0] >= "2023-02-01" AND [Date_0] <= "2023-02-28"
[Date_0] >= "2023-03-01" AND [Date_0] <= "2023-03-31"
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-04-30"
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-04-30"
[Date_0] >= "2023-05-01" AND [Date_0] <= "2023-05-31"
[Date_0] >= "2023-06-01" AND [Date_0] <= "2023-06-30"
[Date_0] >= "2023-07-01" AND [Date_0] <= "2023-07-31"
[Date_0] >= "2023-08-01" AND [Date_0] <= "2023-08-31"
[Date_0] >= "2023-09-01" AND [Date_0] <= "2023-09-30"
[Date_0] >= "2023-10-01" AND [Date_0] <= "2023-10-31"
[Date_0] >= "2023-11-01" AND [Date_0] <= "2023-11-30"
[Date_0] >= "2023-04-01" AND [Date_0] <= "2023-12-31"

Iterative Macro

Accepted answers

All comments

alexnajm

Sounds like you need a batch macro! It can take a list of these dates and run the workflow based on the number of records you feed into it.

Having the workflow would be beneficial so we can help further!

Sg2468_80

Can't attach the complete workflow attaching the screen shot of filter that need to be updated every time when i run workflow.

Fills_0 or Date_0 column is created dynamically from cross tab tool. using this filter, we get different number of records, but they can only be identified when we apply that filter.

workflow_screenshot.PNG

alexnajm

I am sorry, but I can't really help further without a workflow or something to work off of - otherwise I am just guessing in building the macro.

What I can do is pass on some resources to help - good luck!

Sg2468_80

Attaching the workflow and sample records

chk2.zip

Sg2468_80

this workflow i have to execute 17 to 18 times after changing the date condition. So I want 17 to 18 filter condition in excel. And worflow iterates for all filter conditions and produce output.

binu_acs

@Sg2468_80 What are you trying to achieve here? If you can provide some more information i think there is a better way of doing this

alexnajm

I was able to build a batch macro that works to run the different date filters one after the other. It looks like the workflow is cut off compared to your real workflow, so I don't know your end product, but this works!

service_fills.yxzp

service_fills.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703