We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Filter on Current Month and all previous months

SimonFEBP
6 - Meteoroid

In my data set I have records with dates in the future and in the past.  I am struggling to figure out how I can filter to only show records with a date in the current month and all previous months. 

 

Any records that are after the current month the workflow runs need to be excluded.

 

Thanks

4 REPLIES 4
caltang
17 - Castor
17 - Castor

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
SimonFEBP
6 - Meteoroid

I can't share any data but hopefully this example helps.  Lets say the workflow runs today, I only want to show the records I have highlighted in green, the reds will not be included.  The same would happen if I ran the workflow in December, the 2 records that have a December date would be included now

caltang
17 - Castor
17 - Castor

Understandable. Here's how:

 

image.png

 

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
SimonFEBP
6 - Meteoroid

Worked Perfectly!  Thankyou

Labels
Top Solution Authors