Dear all,
I have a duration column with the following app formula: today()-Date([Hidden_Date Submitted])
[Hidden_Date Submitted] is a change timestamp column.
Why is the result for the Duration column 444664:00:00.000 ? Why is the result not in days? Itโs not even in hours.
-j- erry
sorry its this formula that is applicable in the if statement:
Date([Hidden_Date TS Submit to PUB])-Date([Change Timestamp For ace])
*Both are change timestamps
Maybe its because Date([Change Timestamp For ace]) is still blank.
Yes, I believe you are correct. You may want to use some logic to return some default duration such as โ000:00:00โ if one of the fields in the expression is blank.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |