Update tool using one prompt to update 2 values in a filter

[andy_vasey]

Hi all,

I have a filter on a Rate of Exchange table and need an update tool to update both of the values of the dates in the filter.

The filter criteria are as follows:

ToDate([dtActiveFrom]) < "2023-06-30" and [dtActiveTo] > "2023-06-30"

I want the user to select only one date from the Date Tool, but update both date values in the filter. How do I do this?

[Clifford_Coon]

Hi @andy_vasey ,

You can use one update tool if the replace values are the same, by using a formula.

The formula will update both instance of 2023-06-30 in the filter.

 

[mceleavey]

Hi @andy_vasey ,

there are a couple of ways of doing this. First, you can create a field in a text input tool or a formula tool and simply overwrite this by connecting the Date tool and overwriting the value. Then in your filter, change it to:

ToDate([dtActiveFrom]) < [Date] and [dtActiveTo] > [Date]

The other way is to attach the Date tool to the filter itself and use the Action tool to overwrite the values:

I have attached an example of this.

For further reading, you might find the following link useful:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-Action/ta-p/35...

I hope this helps,

M.

[binuacs · Accepted solution]

@andy_vasey another way

[andy_vasey]

Many thanks for both replies. All good now.

[OllieClarke]

@andy_vasey If one or more of the replies helped you, could you please mark them as a solution so others with the same issue can more easily find answers.

Cheers,

Ollie