Skip to main content
Question

Duration Formula

  • June 19, 2022
  • 0 replies
  • 101 views
Forum|alt.badge.img+3
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
------------------------------
This topic has been closed for replies.

Hello Jamie,

For calculating simple duration, We have "Formula - Duration" as field type available in Quickbase.
Few changes required here are :
  1. Change field type of "Days Open/Advisor Actively worked" to formula - duration.
  2. Formula Modification :- If([Status]="Complete", [Date Completed] - [Date Advisor Received] , Today() - [Date Advisor Received])
The 1st Date Client Advisor Received comes back with error Field not identified.  - this is because in your formula you have two square brackets instead of one. 

Hope it resolves your problem. Looking to hear back from you!

------------------------------
Pranav Choudhary
Quickbase Expert Builder Certified by Quickbase
beniwalpranav@gmail.com
------------------------------
Terms & ConditionsAccessibility statement