Duration returning unexpected big value (444664:00:00.000)

[Jerry_Lan]

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

[Jerry_Lan]

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

[Jerry_Lan]

Maybe its because Date([Change Timestamp For ace]) is still blank.

[Suvrutt_Gurjar]

Jerry_Lan:

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.