Skip to main content
Question

Record aging based on most recent of multiple date fields

  • August 14, 2019
  • 0 replies
  • 25 views

I am looking  to get to the number of days since the last date entered among multiple fields, whichever is the most recent. I have the following date fields: date entered, first assessment complete, finance review complete, and final review complete date. I want to see aging (excluding weekends) based on the most recent of the date fields.
    This topic has been closed for replies.

    It would be something like this as a formula numeric field.

    var date MaxDate = Max([date entered], [first assessment complete], [finance review complete], [final review complete date]);

    WeekDaySub(today(), $MaxDate)


    • NoreenJustice
    • Author
    • Quickbase Alumni
    • August 14, 2019

    Thanks for the quick response. Getting an error message: "The types of the arguments or the number of arguments supplied do not meet the requirements of the function Max. The function is defined to be Max ( x, y, ...)."

    Is it because one of the fields is a formula date?

    [date entered] formula date

    [first assessment complete] date

    [finance review complete] date

    [final review complete date] date/time;


    Try this

    var date MaxDate = Max([date entered], [first assessment complete], [finance review complete], ToDate([final review complete date]));

    WeekDaySub(today(), $MaxDate)
    • NoreenJustice
    • Author
    • Quickbase Alumni
    • August 14, 2019
    Bingo! ToDate to convert the date/time field worked. Many thanks! 
    Terms & ConditionsAccessibility statement