Interface Date tool not replacing the Date

Question

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.

Test.yxwz

Raj · Answer

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.

WeiLi · Answer

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

JosephSerpis · Answer

Hi @Ben020283 I just tested your app via the Debug mode (View - Interface Designer - Test View - Open Debug Mode) and it updated the dates.