date range forumla

578 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
4 - Data Explorer
4 - Data Explorer

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')