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
Solved! Go to Solution.
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 : )
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
hi one more thing if my date is in same yyyy-mm-dd format than do i have to use the datetimeparse
If it is already on the yyy-mm-dd format you can just use the ToDate() formula.
hi
i have a two filter that creates two output but with ur macro its only generating one output instead of two,