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

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

WeekDaySub(today(), $MaxDate)