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,