Filter rows that have values older than 18 months

[Daniela_Arenzana]

Hello,

I'm trying to filter/remove rows that are older than 18 months. Can this be done in one formula?

Date	Group	Item
4/2018	TOOLS	5900A
5/2018	TOOLS	5900A
12/2018	TOOLS	5900A
1/2019	TOOLS	5900A
7/2019	TOOLS	5900A

Thank you,

Daniela

[CarlDi]

hi @Daniela_Arenzana - you can create a datetimetoday field in the formual tool and once you convert your current "Date" field into the alteryx format, use a datetimediff expression - then with the filter tool, remove entries that are greater than 180 days. hope that helps!

[Kenda · Accepted solution]

Hi @Daniela_Arenzana 

I would just use a Filter tool with this expression:

DateTimeDiff(DateTimeToday(), DateTimeParse([Date], "%m/%Y"), "months")>18

The reason you have to use the DateTimeParse in the middle is so that the incoming date is formatted correctly in order to find the difference.

Hope this helps!