Help

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

date range forumla

247 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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: 

IF(AND(IS_AFTER(NOW(), {Start Date}), IS_BEFORE(NOW(), {End Date})), 'Active', 'Inactive')
 
Cheers!