6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Using Text Input for a date Filter

7 - Meteor

Hello everyone!  I have an issue I need help with.  I run a workflow daily but it is only a monthly view.  Currently, there are multiple date filters that I use (> 2017-07-01, < 2017-07-01, etc.) but they are all based on the current month.  Is there a way to use a text input tool (or something else) where I can enter the date once and then use that as the date field for my filters or another way to dynamically change the date?  It should be that I need the date to change on the 2nd day of the month.



9 - Comet

Hey Allison, 


I believe what you're asking is to have all your filters go to the current month? If so, you can use something similar to the below in your Filter:

[Your Field] = DateTimeFormat(DateTimeFirstofMonth(), "%Y-%m-%d")

That should get you the first day of the current month in the format example you provided and you can switch the = for <,>,<= etc.


Hope this helps! 





11 - Bolide

Attached an example of an app.

To execute it, you need to press the button selected.Capture.JPG






Is this what you are looking for?