Getting different data on app vs editor

[EricBWS]

Can anyone tell me why I am getting different results from my format rules in the editor vs on the app on phone or desktop. The serial number shouldnt have the little rain drops until it is 6 months old, as you can see in my editor view it doesn't, but on the phone view it does? Ideas?

[AleksiAlkio]

What is your formula in the condition rule?

[EricBWS]

AND(HOUR(
TODAY() -
MAX([Related Machine Cleanings][Date])
) / 24 > 180, DATE([Install Date M/Y])<TODAY()-120)

[AleksiAlkio]

Is the same happening with all rows?

[EricBWS]

It is happening on multiple rows.

[AleksiAlkio]

But is it happening for all of them? Just trying to understand if the formula works at all.

[EricBWS]

Yes the formula works, I am just seeing different data on the phone version of the app versus on the editor version of the app.

[AleksiAlkio]

Server sync set as ON?

[EricBWS]

Server Caching - ON

Delta Sync - Off

Quick Sync- Off

All app to clouds ON

[AleksiAlkio]

Change the Server caching to off and test.

[EricBWS]

Still getting different data, look at these screenshots, one is from the test formula button showing an "N", the other is from the app on my phone,  can anyone make it make sense, because I cant.

[AleksiAlkio]

To find out the reason, I should see your app and it's definitions. If you are able to do that, please send me a PM.

[EricBWS]

I selected Row Number and resorted all the format rules and now it seems to be working, I think maybe it was the row number selection

[AleksiAlkio]

Okay good!