Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
421 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.