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
Hey Mark,
I'm not needing to record the date - the date is manually entered and then once that date is entered I have a formula field that tracks the number of days that have passed since that date was entered.
Then as the record Approval Status is updated by the user selecting completed, or selecting completed previous plan I no longer need the field tracking the # to continue to count.
------------------------------
LB
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendLike Gary says, there is no magic way to have it. "stop counting".
Rather, you are calculating the duration between two dates and therefore you need to know when the start date is, (that is easy because you have that field) but the question is when the end date is. The end date is either today which keeps moving or another date that needs to be recorded somehow as an end date.
So either you need to change your field property to be an Append Only" and log changes, and therefore you will get the end date from there, or else you will have to have a Pipeline run to detect when the record is saved, and the status changes to a certain status and records the current date into a field.
My suggestion is to make your status field be set to Log changes.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------