AnsweredAssumed Answered

"and" operator within Case function

Question asked by JosephSchueller_1 on Jan 16, 2014
Latest reply on Jan 16, 2014 by JosephSchueller_1


"and" operator within Case function



     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!