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