Date interface tool not pulling in dates

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!

sample workflow.yxwz

Workflow

Developer

Developer Tools

Date Time

Interface Tools

Accepted answers

apathetichell

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

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

All comments

apathetichell

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

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

sample workflow.yxwz

apathetichell

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

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

parsed file.xlsx

calendar.PNG

apathetichell

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703