JamieStrauss
3 years agoQrew Member
Duration Formula
Help! While fairly new to "fun" with formulas, I am trying to calculate a simple duration. I've got field "Date Advisor Received" and "Date Completed" Both are Date Type fields. I've added another field "Days Open/Advisor Actively worked" Formula Numeric
I'd like the days to calculate when the Date Completed Field is not populated.
My formula:
IF([Status]="Complete", ToDate([[Date Client Advisor Received]]) - ToDate([[Date Completed]]) , Today() - ToDate([[Date Client Advisor Received]])
The 1st Date Client Advisor Received comes back with error Field not identified. HELP please!
------------------------------
Jamie Strauss
------------------------------
I'd like the days to calculate when the Date Completed Field is not populated.
My formula:
IF([Status]="Complete", ToDate([[Date Client Advisor Received]]) - ToDate([[Date Completed]]) , Today() - ToDate([[Date Client Advisor Received]])
The 1st Date Client Advisor Received comes back with error Field not identified. HELP please!
------------------------------
Jamie Strauss
------------------------------