Using the workdate field in a fomula

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
I am trying to calculate how many days late a project assignment is using a workdate field.  I have tried the following formula:

If([Status] = "Completed", null, ToDays(Today() - ([Due Date])) <= 0, null, Today() - [Due Date])

But because I have predecessors in my steps I have to use a workdate field.  I thought i could convert the Due Date to another formula in Date format and use it but I am unable to do that either.

Any suggestions?
Photo of Scott

Scott

  • 238 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
assuming Due date is the Workdate field type, maybe try this

If([Status] = "Completed", null, ToDays(Today() - (ToDate([Due Date]))) <= 0, null, Today() - ToDate([Due Date]))