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 s...
I’ve now played around with it a bit more and added a column to determine “today” separately and fixed my “and” statement. Still not working.
IF( (AND (Today >= StartDate), (Today <= EndDate)), “Yes”, “No”)
