
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:09 AM
Please could you help me to understand how to make this work?
Thank you!
IF(NOW(IS_AFTER({Announcement Start Date}&IS_BEFORE({Announcement End Date}, ‘ACTIVE’, ‘INACTIVE’))))
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:46 AM
hey @Shonet_Hockley,
your whole formula has many issues. please try the following one:
if(and(is_after(now(),{your date field}),is_before(now(),{your date field})),‘Active’,‘Inactive’)
please feel free to text us back if you have any other issue.
Yours sincerely,
Dimitris Goudis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:44 AM
You know how you sometimes need a different word order when translating from English to a foreign language? You sometimes need a different word order when translating English to a formula field.
IF(
AND(
IS_AFTER(
NOW(),
{Announcement Start Date}
),
IS_BEFORE(
NOW(),
{Announcement End Date}
)
),
'ACTIVE',
'INACTIVE'
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:46 AM
That helps. I’m a linguist so makes perfect sense. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:46 AM
hey @Shonet_Hockley,
your whole formula has many issues. please try the following one:
if(and(is_after(now(),{your date field}),is_before(now(),{your date field})),‘Active’,‘Inactive’)
please feel free to text us back if you have any other issue.
Yours sincerely,
Dimitris Goudis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:46 AM
Thanks. No need to make me feel bad about it :grinning_face_with_sweat:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:49 AM
I tried this and it doesn’t quite work yet. I wonder if I’ve put the words in the wrong order… It is labelling all records either active or inactive whereas I need the status to say ACTIVE only if the date is between the start and end date. Thanks you for your help!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:53 AM
Got it! The words ACTIVE and INACTIVE were the wrong way around. Thank you all!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 05:54 AM
Hopefully you know I was saying this in jest - Computer chat has no humour! haha Thank you

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 09, 2022 06:43 AM
It has no soul either. :expressionless:
