What is wrong with this formula?

[Shonet_Hockley]

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

[kuovonne]

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

[Shonet_Hockley]

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

[Dimitris_Goudis · Accepted solution]

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

[Shonet_Hockley]

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

[Shonet_Hockley]

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!

[Shonet_Hockley]

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

[Shonet_Hockley]

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

[Bill_French]

Shonet_Hockley:

Computer chat has no humour! haha

It has no soul either. :expressionless: