# Re: What is wrong with this formula?

Solved
Jump to Solution
439 0
cancel
Showing results for
Search instead for
Did you mean:
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
9 - Sun

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

8 Replies 8
18 - Pluto

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

``````
5 - Automation Enthusiast

That helps. I’m a linguist so makes perfect sense. Thank you!

9 - Sun

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

5 - Automation Enthusiast

Thanks. No need to make me feel bad about it :grinning_face_with_sweat:

5 - Automation Enthusiast

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!

5 - Automation Enthusiast

Got it! The words ACTIVE and INACTIVE were the wrong way around. Thank you all!

5 - Automation Enthusiast

Hopefully you know I was saying this in jest - Computer chat has no humour! haha Thank you

17 - Neptune

It has no soul either. :expressionless: