Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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