Ongoing configuration to remove last months

maxi_reperger

Hi everybody,

I'm working on a dynamic workflow where from a data set that contain many dates, I need to remove the current and last month entries every time this process will run on a monthly basis.

I've been able to set up the workflow to filter the entries with data from the current month, however I've not been able to set anything to pull the date from "Current Month -1" let's say.

Any thoughts?

Thanks !

Treyson

I am going to expand a little on @DanS reply, which does solve the current month and previous month problem for the most part. However, January can be difficult with this solution since the number value for 1-1 = 0, instead of 12, which is what covers December (January's Previous Month). The other thing that we would probably need to take into account in larger data sets is the year. If we are looking at just the month of the date, you may end up removing the current and previous months for all years in the data set. I hijacked Dan's workbook and added a few things to demonstrate his solution, but expanded to solve these other things. The cool thing about Alteryx is that there are like... a billion ways to solve a problem. I added a second example on that workbook that is a singular formula that should cover everything we have talked about here. Let me know if you have any questions.

Month_Check.yxmd