Stop counting duration
I have a date field that needs to count the number of days that have passed from the date entered AND also need to the field to stop counting when a status is changed to completed or completed previo...
Forum Discussion
I need the counting field to stop counting when the approval status field is changed to complete or previously completed
------------------------------
LB
------------------------------
Logically, your formula isn't "counting" but it's dynamically calculating the difference between two dates (aka the duration). You always need to provide two dates in order to calculate a duration.
You have two scenarios:
- Calculate the difference between POC Due Date (a date) and today (a date)
- Calculate the difference between POC Due Date (a date) and "when the approval status field is changed to complete or previously completed" (not a date)
For #1, you have two dates. But for #2, you only have one date.
Behaviorally, you want to "stop counting" "when the approval status field is changed to complete or previously completed", so you need to know the date on which to stop counting. Therefore, you need to record that date in a fourth field.
This is the way.
------------------------------
gary
------------------------------