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.
So you'll want to bring a summarise tool in using a MAX action and append that back to your original data (using an append fields tool). This will create you a new column (of the max date in the data set) which can then be used in a formula tool expression.
I'll mock up a quick example.
If this solves your issue please mark the answer as correct, if not let me know!