I was wondering if is is possible to use the DateTimeNow Tool in conjunction with the Action tool to dynamically update the DateTime constraint in the InputData tool?
Basically get the current DateTime, use the Formula tool to back calculate a date and then use those two values to update a standard SQL date constraint in a where clause.
Solved! Go to Solution.
I think what you're looking for is the Dynamic Input tool! You can calculate your start & end dates based on DateTimeNow in a formula, and then you can update your WHERE clause in the Dynamic Input tool configuration. You'll basically create a starting SQL statement, then choose the option to Modify SQL Query. You can then Add parameters that change the dates in your WHERE clause by selecting the "Add" drop-down and then choosing either "Replace a Specific String" or "SQL: Update Where Clause".
Check out this Tool Mastery article for more info: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946
Hope that helps!
Cheers,
NJ
Thanks. The video in the link was on-point.