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

[Jonas]

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...)%2Ctrue))

[tony1]

@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.