# Using a formula to get the earliest/latest date across several fields

**URL:** <https://air.tableforums.com/t/using-a-formula-to-get-the-earliest-latest-date-across-several-fields/145>\
**Category:** Tips & Tricks\
**Created:** [February 1, 2023, 9:45pm UTC](https://air.tableforums.com/t/using-a-formula-to-get-the-earliest-latest-date-across-several-fields/145 "2023-02-01T21:45:09Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\
**Post date:** [February 2, 2023, 4:09am UTC](https://air.tableforums.com/t/using-a-formula-to-get-the-earliest-latest-date-across-several-fields/145/3 "2023-02-02T04:09:44Z")

</div>

This is such a fantastic & useful tip, @Kuovonne!!

Thank you for sharing these excellent formulas, and also for reminding all of us about the incredibly useful Unix millisecond timestamp. 🤠 🙌

On a somewhat related note to @kuovonne’s tip:

If you want to lookup a field from another table, but you only want to lookup data from whichever linked record contains the earliest/latest date, you can start with @kuovonne’s formulas in the linked table, and then use the extra tricks that I discuss in the BuiltOnAir podcast episode below.

[![](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/50e523d93dadcb0558342594220a8fe79f110380.jpeg "[S10-E01] Full Podcast for 01-04-2022") ](https://www.youtube.com/watch?v=T9RWQndgKoQ)

Hope this helps! If you’d like to hire the [best Airtable consultant](https://www.scottworld.com/airtable) to help you with anything Airtable-related, please feel free to contact me through my website: [Airtable consultant — ScottWorld](https://www.scottworld.com/airtable)

---

_[View the full topic](https://air.tableforums.com/t/using-a-formula-to-get-the-earliest-latest-date-across-several-fields/145)._