What is wrong with this formula?

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

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

2 Likes

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

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

1 Like

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

1 Like

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!

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

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

It has no soul either. :expressionless:

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.