I am using this formula in a slice to show expiry dates within the next 90 days:
([Expiry Date] <= (TODAY()+90)), ISNOTBLANK([Expiry Date])
At the minute the formula is working for the 90 days and I canโt see records that expire after 90 days. HOWEVER, I am still seeing records that have already expired (see below)
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |