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?
Solved! Go to 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
Thanks Roland, worked like a charm!
Hi Qui, this for some reason gets me all months in 2019, instead of from September 19 onwards!