Days since last updated

[Colin_Lough]

I have 2 columns in my table where I am trying to calculate the number of days since the row was last updated.

The ‘last updated’ column is a ChangeTimestamp watching columns for changes.

The ‘DaysSinceUpdate’ is a number column with App Formula = HOUR(TODAY() - [Last Updated]) / 24

When I look at a details form I get a ‘-1’ result on the field, but when clicking into the form view the correct duration shows. What am I missing?

Details View

Form Voew

[Colin_Lough]

Also seeing my data source has the value ‘-1’ which is incorrect

[Colin_Lough]

This is actually a different problem. The ‘-1’ value is because the form has not populated a value in the row yet.
So - the field ‘DaysSinceUpdate’ is not being triggered or calculated until I open the form view.
Should I be using a formula in my data source to calculate this instead?

[Marc_Dillon · Accepted solution]

App Formula expressions in real columns will only re-calculate when the record is edited.
App Formula expressions in virtual columns will be re-calculated upon every sync.

[Colin_Lough]

Doh! Thank you, @Marc_Dillon