What is the proposed idea/solution? Frustratingly there's still no Max_Date() or Min_Date() function to use within formula fields. There is obviously Max() and a Min(), but ultimately they're designed for checking numbers and returning the largest or smallest, and not dates. How does is solve the user problems? Have a read through this and you'll get an idea of the users struggle. 4 years have passed, and I face this exact same issue again now. https://community.airtable.com/t5/other-questions/how-do-i-return-the-most-recent-of-two-dates/td- In my case, I'm trying to write; MAX(LAST_MODIFIED_TIME({Movie}),LAST_MODIFIED_TIME({Network})) But unfortunately the Airtable Formula returns a zero. Ultimately, I'd like the ability to write this; MAX_DATE(LAST_MODIFIED_TIME({Movie}),LAST_MODIFIED_TIME({Network})) or MIN_DATE(LAST_MODIFIED_TIME({Movie}),LAST_MODIFIED_TIME({Network})) And have the date returned. Importantly, the above needs to work with an array of dates, and not just two. So for example; MAX_DATE(LAST_MODIFIED_TIME({Movie}),LAST_MODIFIED_TIME({Network}),LAST_MODIFIED_TIME({Coverage})) or MIN_DATE(LAST_MODIFIED_TIME({Movie}),LAST_MODIFIED_TIME({Network}),LAST_MODIFIED_TIME({Coverage})) Who is the target audience? Anyone who's needing to simply compare an array of dates within a formula field and have the largest (or the smallest) date returned, with the correct date formatting applied to the return.
... View more