Filter out upcoming months

[Rayyl]

Hello Guys,

I have attached an Excel file. My problem is actually relatively simple i think, so it probably won't be difficult for you. I would like to filter out all coming months that would not be relevant for my Excel.

So for example: It's September and i'm creating a list for August. My goal is to contain only specific rows that really occurred in August. The column with the important month in this case is "K". 

Do you have a solution for me? Thanks in advance!

Best Regards,

Christian

[caltang · Accepted solution]

Hi @Rayyl Christian,

You can try the following as attached.

[caltang]

Basically, what I've done is made a filter that calls the month that you want to analyse based on the dates in Column K.

Now, the code is:

DateTimeFormat([Inv#-Rel# date],"%B") = "August"

Where %B references the full name of the month based on the date you have in Column K. 

[caltang]

I've also made it into an analytic app for you so that you can play with the interface and choose one of the months of your interest to browse or export. Now, this requires some configuration on your own end to make it as dynamic as you'd like, but it gives you an idea of what is possible on Alteryx. Happy solving!