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

[pjandliz]

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

[MarqueeCrew · Accepted solution]

@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]

Hi

This is what I've set up - I've even split out the filter formula into 2
parts with the Start & End data actions acting on separate Filter Tools but
with no success.

Attached is the workflow with a Text Input tool with some sample data. It
seems to be ignoring both Start and End date (I thought the Start date was
OK but I may not have noticed it being wrong or changed something to break
it).

Many thanks.

Kind regards

Paul

[pjandliz · Accepted solution]

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/t...

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.

[danilang]

Hi!

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

In this case, since @MarqueeCrew provided guidance in helping you find the solution, I've marked his reply as a solution as well.

Thank you!

Dan