Filter date value from textbox year input

[blielb]

Hello,

Hello, I am a beginner in Alteryx and I need your help with this topic please. My goal is to filter based on a 01-01-YEAR entered by the user in a textbox (ex 2024). I am unable to do this using the textbox and the action tool. I have provided an example workflow with an explanation in the FILTER component. The result I want, if we take the example of 2024 entered in the textbox, is to keep only the row with the date 2024-05-05. so filter will contain something like that : DATE > 2024-01-01

thank you in advance

[ChrisTX · Accepted solution]

See attached workflow.  I used the ToDate function in your Formula tool.  And in the Action tool, I used the checkbox to replace a specific string.

In the Interface Designer settings, I also checked the option to display the output of the Browse tool.

Chris

[blielb]

Hi ChrisTX, thank you so much, it works, the checkbox to replace specific string is what doesn't know

Can you please confirm if we can use only one action for many other filters or I need to add one action for each filter needed ? 

thank you so much

Badr 

[ChrisTX]

@blielbSee the examples on the Tool Mastery page for the Action tool:

https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Action/ta-p/35500