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

[Ellen_Edgerton]

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”)

[kuovonne]

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.