Skip to main content

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

  • March 6, 2020
  • 1 reply
  • 0 views

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

kuovonne
Forum|alt.badge.img+17
  • Brainy
  • 5993 replies
  • March 6, 2020

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.


Reply