using date filter

[pokhan27]

HI Sme

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

Name	Due date	process
abc	01/12/2021	complete
xyz	12/12/2021	pending
bnd	02/01/2021	in 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

[atcodedog05]

Hi @pokhan27 

You can do it using an app.

Workflow:

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

Hope this helps : )

[pokhan27]

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

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

[atcodedog05]

Hi @pokhan27 

It will be linked using the action tool

Hope this helps : )

[pokhan27]

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

[gabrielvilella]

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

[atcodedog05 · Accepted solution]

Hi @pokhan27 

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

Hope this helps : )

[pokhan27]

hi 

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