Count based on time difference doesn't work ...

expressions
(Jonas /) #1

Count based on time difference doesn’t work

=count(select(product_audits[product_id],and([changed]=“Online”,[user]=useremail(),now()-[created_at]<“24:00:00”),true))

When I test the expression in the backend it counts 3, but in the app the value is 0

The problem only occurs in Chrome, Firefox counts fine.

APP: Einstellen-225603

ThX

https://www.appsheet.com/template/showtable?appName=Einstellen-225603&schemaName=virtual_cols_Schema&expressionColumnName=done_today&tzOffset=-60&locale=de&location=50.9434117%2C%206.8462498&settings={"_RowNumber"%3A"0"%2C"_EMAIL"%3A""%2C"_NAME"%3A""%2C"_LOCATION"%3A""%2C"Options%20Heading"%3A""%2C"Option%201"%3A""%2C"Option%202"%3A""%2C"Country%20Option"%3A""%2C"Language%20Option"%3A""%2C"Option%205"%3A""%2C"Option%206"%3A""%2C"Option%207"%3A""%2C"Option%208"%3A""%2C"Option%209"%3A""%2C"_THISUSER"%3A"onlyvalue"}&expression=%3Dcount(select(product_audits[product_id]%2Cand([changed]%3D"Online"%2C[user]%3Duseremail()%2Cnow()-[created_at]<"24%3A00%3A00")%2Ctrue))

(Tony Fader) #2

@Jonas Very weird. Can you give me the example values where the

NOW() - [created_at] < “24:00:00”

is giving you the wrong value. That will make it easier to debug.