3 Replies Latest reply on Jan 16, 2014 9:05 AM by JosephSchueller_1

    "and" operator within Case function

    JosephSchueller_1

      Title

      "and" operator within Case function

      Post

           Hi,

           This seems like something I should be able to figure out easily, but I'm just stuck. I have a calculation that looks like this:

           Case(Date>=1/1/13 and Date<=12/31/13; "X")

           It doesn't return"X" when it should, and I can't figure out why. Any ideas? Thanks!