date range forumla

[SondraWithAnO]

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.

[Charlie_Melende]

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!