I have a property that calculates the time between two dates but it is sometimes calculating correctly and sometimes not… Any ideas what the root cause may be?
Hey @JTranbarger
The main cause could be the incorrect calculation set in the properties you can get help from this Knowledgebase and make sure you have created the correct properties so that it calculates the time between two dates
Let me know if you have any followup questions.
If my post was helpful in addressing your query, Support the community by indicating it as the solution
Did you solve this?
I had the same and it turns out that calculation properties with time between do not function correctly for custom fields. If you have a custom field only the date - not the time (!) - is available for calculation properties.
So, even though you can see the exact time (e.g. in the custom date property details) the calculation of time between will calculate from midnight.
This is documented here: Create calculation and rollup properties.
Obviously this is daft. There is an Ops Hub workaround but I can’t be the only one that has ended up looking at “wrong” time between hours reports!
At least I will make a request to fix