Closest Past Date from a list of dates
I need to come up with a formula that evaluates the closest past date from a reference date. For example, If the dates are Jan 2022, May 2022 and my reference is April 2022, then I must go with Jan 20...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAre these various past dates in a child table? Is the reference date on the parent record and the child Table has all of the possible past dates to evaluate?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------