New user, pulling my hair out here. I’m trying to write an extremely simple column formula to calculate whether a product is out of warranty. It looks at a “warranty good through” date field and compares it to TODAY, showing whether a warranty is Active or Expired.
IF({Warranty Exp}<TODAY(),“Active”,“Expired”)
This returns “Expired” for every solution.
It will, however, return “Active” if {Warranty Exp} is blank?
Got it! You have to use both the IF and DAYS formulas:
IF(DAYS({Warranty Exp},TODAY())<0,“Active”,“Expired”)
DAYS will compare the number of days between two dates.
If I use that, it returns “Illegal Formula” ?
Nevermind that - just had to include some spacing in the formula. Working fine!
Thanks!