Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

using date filter

pokhan27
8 - Asteroid

HI Sme

i need to create a due date filter but it has to be dynamic. 

NameDue dateprocess
abc01/12/2021complete
xyz12/12/2021pending
bnd02/01/2021in process

 

i want to create a dynamic filter where user can insert the date manually 

 

current stage:

process = "Pending" OR "in process" AND  Due Date <2/28/2022 

 

this is a monthly report and due date changes every month so i want to create a filter that gives user to input the date and then do the filter based on the date entered by the user

 

 

thank you again

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @pokhan27 

 

You can do it using an app.

 

Workflow:

atcodedog05_0-1643298673009.png

 

Learn more about this here: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...

 

Hope this helps : )

pokhan27
8 - Asteroid

hi 

how do you link the due date column with the date app? 

for example: if i select the date from the app less than 08/09/2021 its still showing the value from 12/12/2021 which is false, as it should be blank

 

pokhan27_0-1643300147148.png

pokhan27_2-1643300181668.png

the underlined date should be the date value from the selected date, tahts what i am looking for

atcodedog05
22 - Nova
22 - Nova

Hi @pokhan27 

 

It will be linked using the action tool

 

atcodedog05_0-1643300278631.png

 

Hope this helps : )

 

 

 

pokhan27
8 - Asteroid

hi one more thing if my date is in same yyyy-mm-dd format than do i have to use the datetimeparse

gabrielvilella
14 - Magnetar

If it is already on the yyy-mm-dd format you can just use the ToDate() formula.

atcodedog05
22 - Nova
22 - Nova

Hi @pokhan27 

 

If the date is in the format you can directly use it like below.

 

atcodedog05_0-1643309106179.png

 

Hope this helps : )

 

pokhan27
8 - Asteroid

hi 

 

i have a two filter that creates two output but with ur macro its only generating one output instead of two,  

 

pokhan27_0-1643379565718.pngpokhan27_1-1643379590969.png

pokhan27_2-1643379627864.png

 

Labels