Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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