Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Dec 09, 2022 08:42 AM
Hi! I'm trying to create a field of active/inactive based on a date range. I already have a field each for start date and end date, but can't figure out how to create the formula for the active field based on those dates. Any ideas?
Thanks! Sondra.
Dec 09, 2022 10:17 AM
Hey there, this can be achieved with a combination of an if() + and() function.
Try this formula and replace the Start Date and End Date with the names of your fields if need be: