Designer| Filter for data using dynamic/rolling date range

Mj9715

Hi All, 

I need to filter monthly data (attached) to include the previous 24 months from the latest month of date . For example if the latest date in input data is Aug-2021, I need to filter for data from Sep-2019 till Aug-2021.

Can someone suggest the best way to do this using DateTime in the filter tool?

TestData.xlsx

RolandSchubert

Hi @Mj9715 ,

you can find the last date in your data using a Summarize tool, add this date to all rows using Append Fields and use a Filter tool to select all rows having [Date] > DateTimeAdd([Max_Date], -2, 'years')

Let me know if it works for you.

Best,

Roland

FilterDates.yxmd