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
Solved! Go to Solution.
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!
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!