Using the workdate field in a fomula
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...
Forum Discussion
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]))
If([Status] = "Completed", null, ToDays(Today() - (ToDate([Due Date]))) <= 0, null, Today() - ToDate([Due Date]))