Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Date Range of One Input Based on Another Input

bertal34
9 - Comet

Trying to filter dates in one input based on start/end dates of a second input.

 

Input2

StartDate = 12/2/2018

EndDate = 12/8/2018

 

Input1

Contains all 365 days in 2018 but want to limit only to the single week in Input2.

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @bertal34

 

There are several ways to do that.

Here's what I thought based on the info you provided. Workflow appended.

Capturar.PNG

Cheers,

bertal34
9 - Comet

@Thableaus

 

Thank you for replying so quickly!  I think you attached the wrong workflow, it doesn't look like the pic below.  Could you provide correct solution?  thanks!

Thableaus
17 - Castor
17 - Castor

@bertal34

 

Try to download it again. I edited now.

 

Cheers,

Labels
Top Solution Authors