Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter data using fixed dates

Rwade
7 - Meteor

Hello Everyone, 

 

I am working to create my first workflow that has 12+ filters, each filter is a basic filter based on a single fixed date.

 

Each of the possible fixed dates will only be one of four fixed dates.

 

Each time the workflow will be ran, the four fixed dates will need to be changed. 

 

It may help to know the four fixed dates are basically random dates with zero relationship to the current date. 

 

The way it looks to me I will have to go back in to manually update all 12+ filters with the revised fixed date. -OR- is there maybe a way I can somehow build each filter to point to a specific reference point, so I only have to update the four dates one time in a single location which will then automatically update all filters in the workflow?

 

Please let me know if maybe have any questions that would help folks better understand my question. 

 

Thank You!

 

  

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @Rwade ,

 

On the workflow configuration window you are able to create your own variables which you can then use on the workflows:

 

In this example I created one with a date to use in the filter.

 

Untitled.png

 

If you need anything else let me know!

 

Regards

Rwade
7 - Meteor

Hello @afv2688, 

 

Very much appreciated, that solution works perfect!

Labels
Top Solution Authors