Forum Discussion

Qrew Trainee

2 years ago

Overdue Duration Formula most be positive # of Days

Hey QuickBase Community, I have a Duration Formula field that is looking at the difference between "today()" and the finish date of a given task record. the field is designed to tell me if the record...

ChayceDuncan

Qrew Captain

2 years ago

You can just check first to see if Finish date is in the future and nullify it. You also don't have to nest each new if as a new statement to make it more readable, you can just do like so:

If(

[Finish Date]>=Today(), null,

[Status]="Overdue",Today() - [Finish Date],
Status]="Not Started",Today() - [Finish Date],

[Status]="In Process",Today() - [Finish Date],

null)

------------------------------
Chayce Duncan
------------------------------

JackWoods
Qrew Trainee
2 years ago
Thank you, Chayce. that worked.

------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------