"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!