Help

Re: What is wrong with this formula?

Solved
Jump to Solution
1178 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shonet_Hockley
5 - Automation Enthusiast
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

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

See Solution in Thread

8 Replies 8

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

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

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

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: