Forum Discussion

JamieStrauss's avatar
JamieStrauss
Qrew Member
2 years ago

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
------------------------------
Formulas and functions

2 Replies

Sort By
  • PranavChoudhary's avatar
    PranavChoudhary
    Qrew Trainee
    2 years ago
    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
    ------------------------------
    • JamieStrauss's avatar
      JamieStrauss
      Qrew Member
      2 years ago
      Worked like a charm! Thank you so much :)

      ------------------------------
      Jamie Strauss
      ------------------------------