Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

What is wrong with this formula?

Topic Labels: Formulas
Solved
Jump to Solution
3156 8
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
Dimitris_Goudis
10 - Mercury
10 - Mercury

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!

Dimitris_Goudis
10 - Mercury
10 - Mercury

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: