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
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;