Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
2 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 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]
);


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

2 Replies

  • 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)
    mark.shnier@gmail.com
    ------------------------------
    • MattMakris's avatar
      MattMakris
      Qrew Cadet
      That worked beautifully, thanks Mark!

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