Error on Date Time Filter?

[dev2]

Hi all,

I’m using a slice for sending a daily SMS, but the slice does not seem to get the expected rows.

I’m trying to get rows that have a “Date Chgt Statut’” within the last 24h (this is my column reporting TimeStamp from another Table).

I tried two formulas (which I think equivalent) in this purpose, but the result is always the same : I’m getting 3 rows instead of 7 expected.

This slice uses a filter formula as following :
[Date Chgt Statut]>datetime(NOW()-1)
Here is the second formula I tried:
AND(NOW() > [Date Chgt Statut], HOUR(NOW() - [Date Chgt Statut]) < 24)

The column field where originally “date” formatted, and my formula was instead :
[Date Chgt Statut]>DATE(NOW()-1) (and not DATETIME)
…the result was still 3 rows.

Here is what I have on the data slice view:

And what I expect :

Do you have any clue of what I’m missing ?
Is it because the missing items are beyond the thousandth row ? I didn’t read about any limiting rows in the appsheet center.

Many thanks for your help,

Aurelien