Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

date range forumla

955 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SondraWithAnO
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
Charlie_Melende
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')
 
Cheers!