How to indicate if a food item has passed its expiration date?

Topic Labels: Formulas
990 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m not quite sure how to go about creating a formula that checks an expiration date (eg date field called “Expiration Date”) against today’s date. I know this formula checks field Expiration Date against another date field called Date, but I need it to always check against the current date, not against another date field.

IF(IF(XOR(BLANK(),{Expiration Date},{Date})=1,"",IF(OR({Date},Expiration Date)=1,IS_BEFORE({Expiration Date},{Date}),"")),“ :warning: Expired”,“Ok”)

1 Reply 1

Use TODAY() for the current date.

Note that the value of is updated only when the formula is recalculated or a base is loaded. It is not updated continuously.

You can find it in the formula field reference.