Can you use 2 actions to update a single filter formula ?

Question

I'm using the Date Tool to get a Start and End Date to pass to a filter; I have the 2 tools connected to a Filter Tool via Action Tools identically however the Start Date update works but not the End Date.

The selected StartDate action replaces the text "StartDate" however the EndDate action doesn't seem to replace "EndDate" in the following Filter formula:

ToDate([Date]) >= "StartDate" AND
ToDate([Date]) <= "EndDate"

Is it possible to do the two replaces in the Filter formula this way? Thx

Alteryx workflow 2.jpg

MarqueeCrew · Accepted Answer

@pjandliz ,

yes!  There's probably an error in the action tool configuration.

make sure that you've selected properly the end date and send us a pic please.

cheers,

mark

pjandliz · Accepted Answer

OK, I've now got this solved finally.

I found the answer in this post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Update-Value-Action-tool-not-working/td-p/424612

I had no idea I needed to select something specific in the Value or Attribute to change box for the Action (now I see the heading, it makes more sense now!) - in the absence of clarity in the 'how to' guide (or a clear enough example) I was under the impression the Action would replace the text value I specified in my filter formula.

Thanks to marqueecrew for taking the time to help me too.