Date Interface tool to Update Formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Date Time
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/F46203A7339C1798EB03AB2274277419/responsive_peak/images/icon_anonymous_message.png)