This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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”)
