Hi All,
I'm still very much a newbie so go easy on me. I'm trying to create a workflow in where I use the Date Interface tool to choose a date and this date is used and updated in the Formula tool. This my first time working with the Date Interface and action tools so I'm sure if I have everything configured correctly.
Solved! Go to Solution.
Hello @tbuenaflor ,
Welcome to the community!
You almost got it right. To be honest, I have never used it like that.
If you want to add it into a formula tool this is what I would recommend you to do:
Type in the formula tool the following
Todate('abcd')
Change the data type to date
Select in the action tool the checkbox 'Replace a specific string' and replace only abcd (NOT 'abcd')
It should work like that 🙂
Regards
@afv2688 Thanks for the quick reply! Your solution worked like a charm. I'm honestly not sure how I went down the rabbit hole of using the Date and Action tools (too much browsing the community forums haha. Below is the formula I originally had where the user had to manually input the date in the formula tool.
Hi The
I am new to Alteryx and I require using the date interface tool. I followed your example and it works great for coming out on my CSV output but it shows as NULL in the Date_Field I created in the formula tool. I have my formula and action tool as below.Any help you could provide would be greatly appreciated
Thx
Stan