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)
Try
and(
[Expiry Date] <= TODAY()+90,
ISNOTBLANK([Expiry Date]))
Thank you for your response.
The same is still happening which Iโm finding strange.
Your syntax of expression seems to need correction.
Also maybe you wish to add the following or similar condition to eliminate the records before today.
AND(([Expiry Date] <= (TODAY()+90), ISNOTBLANK([Expiry Date]), [Expiry Date]> (TODAY()-1))
Works brilliantly minus one of the open brackets after the AND. Thank you very much.
Oh yes, thank you, there was a typo. Good to know it works, the way you wish. Corrected it as below and also optimized the expression a bit more.
AND([Expiry Date] <= (TODAY()+90), ISNOTBLANK([Expiry Date]), [Expiry Date]>=TODAY() )
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |