It’s been too long since I’ve done complex formulas… I’m trying to identify active contracts. On each contract record I have a start date and an end date. I also have a column where the formula sits, looking for active contracts. This looks like it should work to me. Any ideas?
IF( ( (TODAY > StartDate) AND ( TODAY < EndDate) ),“Yes”,“No”) )
Thanks in advance.