We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Interface tool Dates

Xandro
6 - Meteoroid

I have created a calender where the user can select a startdate and an enddate. My intention is to save the workflow in the Gallery where the user via the interface dates can select the two dates startdate and enddate. See attached the workflow. If I run the workflow from the Gallery the output will generate no records. Can someone help me and explane what i do wrong.

 

Thanks in advande for your help

2 REPLIES 2
davidskaife
14 - Magnetar

Hi @Xandro 

 

I'm unable to run it as you've included links to a file which hasn't been included. However I have noticed this error on the first Formula tool, it's not liking the 'Monthend' part - what are you trying to do?

 

Screenshot 2025-06-26 094754.png

apathetichell
20 - Arcturus

my magic powers are telling me this should be datetimetrim(datetimeadd([Endddate],1,"month"),'lastofmonth')

Labels
Top Solution Authors