Hi again, I’ve been playing around with ternary operators, as documented at the bottom of this page:
In theory, I should be able to use a ternary operator inside a single date or text field, using [LANG_LOC]==“en_US” as the conditional_operation, and output either the USA or non-USA date format based on this conditional. This would mean I can have just one date/text field, instead of needing two of them and manipulating the opacity of each one.
There’s also another post here: Using ternary operators in text field – which confirms that ternary operators should work inside a text field.
However, I’m stuck with this and I wonder if I’ve encountered a bug.
For example, this works correctly:
(([LANG_LOC]==“en_US”) ? “USA” : “Not USA”)
And so does this, using a single tag for the “result_if_true” result:
(([LANG_LOC]==“en_US”) ? [MON_F] : “Not USA”)
But if I try to add more than one tag for the “result_if_true” or “result_is_false”, then it doesn’t work and just outputs the entire ternary operator:
(([LANG_LOC]==“en_US”) ? ([DAY_WEEK_S], [MON_F] [DAY_1_31]) : “Not USA”)
I’ve tried using various combinations of parentheses around the tags, but I can’t get it to work if there is more than one tag in the result.
Can you get it to work? Any ideas?