Limit all input data based on a date parameter

Question

Hi!

I have a situation where a flow has many inputs with data that has some date type fields. 
I would like to be able to input somewhere a specific date (global variable?) and based on that constraint_date adjust input queries dynamically or somehow else.

I am struggling to come up with a clean solution. So far only idea I have is to make a macro with control parameter which could be used for each input, but then the control parameter has to be connected to each of those macros in any flow used anyway, which makes it messy and inelegant.

Any ideas would be greatly appreciated!
Thanks, 
Nora

citronmelisa · Answer

Thanks @cvalteryx. Not quite what I am looking for though, as I want to limit records that are retrieved from database, not filter them down afterwards.

citronmelisa · Answer

Hi, @DawnDuong!
This is the version I have currently settled on (taking that user constant into all dynamic inputs where necessary). 
However, it is not perfect, I would have liked it if it was available to use straight away in dynamic input query, instead of having to connect it into each input that will need it. 
Guessing this might be the best simple solution there is, though.

Best regards, 
Nora

DawnDuong · Answer

hi @citronmelisa

If I read the ask correctly, perhaps you can try create a user-specified constant. See details in the link below:

https://help.alteryx.com/20221/designer/constants

Add a User ConstantIn the Workflow tab of the Workflow - Configuration window...

* Select the add (+) button.
* Enter a Name and Value.
* Select the check box in the # column if the value is a number. By default, constants are strings.

Regards,
Dawn.

UserSpecifiedConstant-Alteryx.PNG