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
19 - Altair

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
19 - Altair

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
19 - Altair

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