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

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. :cowboy_hat_face: :raised_hands:

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.

Sorry, it’s late here & I’m about to go to sleep, so I’m just being lazy by linking to my video. :stuck_out_tongue_winking_eye: But in the future, I’ll come back & type out the full instructions here!