Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
Logical Operators

Logical Operators

Use logical operators in expressions to test for a condition. Logical operators define Boolean expressions.
You might want to use logical operators in Filter transformations or CASE expressions. Filters test if a field or value meets some condition, such as testing if the value in a Date field falls between 2 other dates:
BETWEEN 2016-06-01 AND 2016-07-31
Operator
Meaning
Example
AND
Test whether 2 conditions are true.
OR
Test if either of 2 conditions are true.
NOT
Reverses the value of other operators.
  • year
    NOT
     BETWEEN 2013 AND 2016
  • first_name
    NOT
     LIKE("Jo?n*")
    Excludes
    John
    ,
    jonny
     but not
    Jon
     or
    Joann
  • Weekday
    NOT
     IN("Saturday", "Sunday")
  • purchase_date IS
    NOT
     NULL
    Evaluates to
    true
     when the
    purchase_date
     field is not empty

This content is not part of the Workday Administrator Guide.