Hi I have a workflow which I has an interface date tool the dates that I am selecting in Interface date tool is not replacing the dates in formula. I am attaching a part of the workflow, can someone assist in finding where i am going wrong. If I remove the " then it gives error that value is number however the type is Date.
Hi @Ben020283 I just tested your app via the Debug mode (View - Interface Designer - Test View - Open Debug Mode) and it updated the dates.
i think your logic is sound and i was not able to replicate your error. i suggest deleting those tools and put a new one back in. sometimes Alteryx feels like it did not save your parameters properly.
see images for results when I replicated what you did, it successfully picked the 2 dates i chose in the interface.
[Note: I've tested both Date data type and String data type. result is the same, they will both work. In the image below, its showing String, but I did test Date type as well]
Image 1 - the dates Jan 15 and Jan 17 was selected to replace Jan 1 and Jan 5
Image 2 - Jan 15 and Jan 17 successfully appears in the resulting output
Image 3 - This shows the setting in the Action Tool for StartDate
This is not pushing any error when I tried your workflow and logic.
I suggest you recreate the specific part or try running the workflow in debug mode to deep dive into error.