Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Interface Date tool not replacing the Date

Ben020283
7 - Meteor

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.

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

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

 

Debug_mode_05012024.JPG

WeiLi
7 - Meteor

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

Capture.PNG

 

Image 2 - Jan 15 and Jan 17 successfully appears in the resulting output

Capture2.PNG

 

Image 3 - This shows the setting in the Action Tool for StartDate

Capture3.PNG

Raj
16 - Nebula

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.

Labels
Top Solution Authors