Forum Discussion

NoreenJustice's avatar
NoreenJustice
Qrew Trainee
6 years ago

Record aging based on most recent of multiple date fields

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.
Formulas and functions

5 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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's avatar
    NoreenJustice
    Qrew Trainee
    6 years ago

    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;


  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Try this

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

    WeekDaySub(today(), $MaxDate)