Hot to get earliest date from list of dates

Question

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
------------------------------

MarkShnierYou · Answer

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------------------------------

Sign up

Login to the community