Skip to main content

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}),"")),“ ⚠ Expired”,“Ok”)

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


Terms & Conditions