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?

[RolandSchubert · Accepted solution]

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

[Qiu]

Hope this would help you.

[Mj9715]

Thanks Roland, worked like a charm!

[Mj9715]

Hi Qui, this for some reason gets me all months in 2019, instead of from September 19 onwards!