I have a project log table that tracks each status change for a related project.
How do I calculate the duration of time in each status?
Essentially the difference (in days) between each record Start Date.
I'm thinking this can be done in a report formula field
+24It's actually an interesting question but I don't recall anyone posting an answer to this type of question. I'm sure it can be done using Formula Queries. You would do one query to get the list of Record ID's which are less than the one you are on. They come back in Record ID sequence so the last one on the list its the highest one. Then parse that number off the end of the string and use Get Field value to access the date field from that record.
If you have a small budget for an hour of consulting time we could get that working on a zoom call and you might learn something about Formula Queries. If not then maybe someone else will post an answer or I'm might get curious when I had spare time and figure it out. The fact that your status updates are in Record ID sort should allow a solution.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
