
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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;
And have the date returned. Importantly, the above needs to work with an array of dates, and not just two. So for example;
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.