Question

If Statement for Exclusive

0

Hi all, i have the following if statement for an exclusive split. Unfortunately, none of the following versions works: formatDateTime($WOHead/ShipmentReady,'EEE') != 'Sat' OR 'Sun' (formatDateTime($WOHead/ShipmentReady,'EEE') != 'Sat') OR (formatDateTime($WOHead/ShipmentReady,'EEE') != 'Sun') Any ideas?

asked 2015-10-17

Tim Baumer

1 answers

Rom van Arendonk · Accepted Answer · 2015-10-17

What exactly is the problem, does the split throw an error, is the result not what you expect or is it something else? Looking at your code, I would say the following:

Your first one appears to be syntactically invalid.

Your second one is aways true. Either change both '!=' to '=', or change the OR to AND.