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

Date interface tool not pulling in dates

sericson
8 - Asteroid

hello all! I have been trying to get the Date Interface tool to work and I cannot seem to figure it out. I'm sure the issue is with a formula or how it is set up and I have scoured the community and can't get anything to work. I've attached a sample of my workflow. what I need to do is be able to select a beginning date and an end date that will change each time the workflow is ran. HELP!

6 REPLIES 6
apathetichell
20 - Arcturus

ok - you're close.

 

filter tool 1 - change where you have #1 to "2024-09-10" - this is a placeholder. don't worry.

filter tool 2 - no changes

action tool one click on filter to expand to value.

click on expression-value

go down to replace a specific string click on it - replace 2024-09-10 - no quotes.

do the same for action tool two.

run via wand.

 

sericson
8 - Asteroid

ok, so I did all of this and the output only gives me 09/10 dates, which is closer than what I was but still not quite right. I probably missed a step. the second filter doesn't look like it's correct

apathetichell
20 - Arcturus

interface designer - click on your browse to show output. run via wand. if you followed my instructions that works. I'll check on your workflow now.

 

ok - both action tools don't have replace a specific string configured correctly. change that value so it only says 2024-09-10 - think of this like a find and replace.

sericson
8 - Asteroid

so I am running via wand and my output is only giving me a single date, not a date range. 

apathetichell
20 - Arcturus

Hey - your first filter term is [Term Date] = "2024-09-10" - this is a single date.

 

did you mean [Term Date] >= "2024-09-10"

sericson
8 - Asteroid

That was it!! thank you SO much for your help!! Truly appreciate it

Labels
Top Solution Authors