Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
3 years ago

Hot to get earliest date from list of dates

I need to return the earliest date in a list of dates in a formula. Any idea how to do this? Here's what I have so far (just the list variable declaration): var list dateList = list( [Date stag...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
var date EarliestDate = Min(
[Date stage set to Ready for Editor],
[Date stage set to Ready to send to client],
[Date stage set to sent to client for approval],
[Date stage set to approved by client],
[Date stage set to Published]
);

------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
  • MattMakris's avatar
    MattMakris
    Qrew Assistant Captain
    3 years ago
    That worked beautifully, thanks Mark!

    ------------------------------
    Matt Makris
    ------------------------------