Update multiple filters with date ranges at once

[YRichardson12]

Is there a simple way to update multiple filters with date ranges all at once? See example picture. How do I update all of the date filters at the same time with start date 10/01/23 with end date 10/31/23? Thank you.

[rzdodson · Accepted solution]

The easiest way I have personally found is to:

1. Create a Text Input tool that has a dummy Start Date and End Date
2. Connect Date tools (Interface palette) to the Text Input tool. Have Date (1) update Row 1, Column 1. Date (2) updates Row 1, Column 2 in your Text Input tool.
3. Put an Append tool between your data stream's intermediary output (i.e. your Select tool) and your Filter. The top input anchor of your Append is where you'll connect your Select tool. The bottom input anchor is where you'll connect your Text Input tool.
4. Alter the logic of your Filter tool to read as such: [Your Date Field] >=[Start Date] and [Your Date Field] <=[End Date]
5. Put a Browse tool at the end of your workflow.
6. Go in to your Interface Designer settings, and select your Browse tool to display the results when your App runs.
   

At this point, you'll have converted your workflow into an Alteryx Analytic App. You'll know it is an App because this icon will appear next to your Run button:

When you go to run your workflow again, you'll click this button. This will show two different calendars, one for each tool, where you can select the start and end date of your analysis. When you then run your app, the Filters will update with the dates you had selected.

Hopefully that helps! Feel free to ask any questions you may need. :)

[rzdodson]

Attached is a non-app/semi-manual approach if you do not want to go the app route. In short, you would create separate Appends for each data stream. Then, the end user of the workflow will need to alter the Text Input tool that contains the Start Date and End Date fields.

[Qiu]

@YRichardson12 
Same as @rzdodson an quick sample as below

[YRichardson12]

Thank you so much!!! This worked!!! Amazing!

[YRichardson12]

Thank you so much! This worked as well!

[KGT]

Another way to do this, and how we handle this at my work, is through Workflow Constants. You can set one up for the start date and one for the end date, then reference those variables in the filter or wherever else it's needed.

I have at different times used either the Text Input solution above or the Workflow Constants, depending on what we were changing or where the variables we're used. We currently use the text input solution with detours into joins (joined with the text input, but working as a filter) to limit to one client processing at a time for testing.