Filter on Current Month and all previous months

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

Date Time

Accepted answers

caltang

Understandable. Here's how:

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/

For Simon.yxzp

All comments

caltang

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.

SimonFEBP

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

Dates.PNG

caltang

Understandable. Here's how:

For Simon.yxzp

SimonFEBP

Worked Perfectly! Thankyou

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703