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'

)

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

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'

)

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!

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

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