This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a dataset with 18 months of data. Each month a new month is appended to the existing dataset. I'd like to create a filter that keeps only the most recent 14 months (rolling 14 months). I've attached a simple workflow.
The Date Filter tool would work if I could dynamically specify the "end date" as the most recent date in the Month column. Any suggestions would be much appreciated.
Hi, Jack, I think your workflow will solve my exact problem as well. Only change would be in my case, I don't want a rolling 14 months. I want it to append every new month starting with 201803. Reason being, I began running this workflow back in March and want to make it more dynamic than adding on a new filter each month.