Spit out my data based upon finding dates from current date to the next 6 month dynamic

[jbedil08]

Hi folks, i'm new to Alteryx so ive been teaching myself for my job and im currently running into a problem I can't seem to fix. I'm trying to have it spit out data based upon dates associated to certain rows that are within the next 6 months. They are based on multiple country dates for one item and if any of the country dates are in the next 6 months, I need that row spit out in the output. I included an excel example for reference. Would also help if the solution was dynamic and i didnt have to always put in the current date. This would be next 6 months based on current month, not exact date in the month. Thank you!!

[binuacs · Accepted solution]

@jbedil08 are you expecting the output like below?

[jbedil08]

Yes that is correct but I would need it for like 15 columns of dates. Would formula would work for that?

[binuacs]

if your dates are in the format of yyyy-mm-dd or mm/dd/yyy then it should work, if you have a different format, then you need to update the formula to convert them into Alteryx Date format.

[jbedil08]

Awesome thank you! Your above workflow worked for me after some tweaks!! Really appreciate it!