Forum Discussion

PriscillaFramar's avatar
PriscillaFramar
Qrew Trainee
7 years ago

How can I get days overdue to stop revving without setting the value to null

I am currently using the following formula which captures the days overdue within the formula field ?Days Overdue? while the status is not equal to Delivered.  I would like to be able to set the s...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Can you post your formula and the complete error message?
PriscillaFramar's avatar
PriscillaFramar
Qrew Trainee
7 years ago

Used what you suggested except Date Delivered is Actual Finish Date.

If(
[Status] = "Delivered"
and [Actual Finish Date] >=  ToDate([Calculated Finish Date]),
   ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])),  

Max(0, ToDays(Today() - ToDate([Calculated Finish Date]))))

 

The line: ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])),   give me the warning of �Expecting Duration but found number�