In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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