This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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’))))
Hi there,
I want to create a field that gives a different message to the user, depending on whether they have filled in a particular field ‘on time’ or not.
I’ve attempted to explain it in text. If anyone could suggest the functions I need to use, I ...
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 yo...
