Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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:
IF(AND(IS_AFTER(NOW(), {Start Date}), IS_BEFORE(NOW(), {End Date})), 'Active', 'Inactive')
Cheers!
