Case ( DateBegan ≤ Get ( CurrentDate ) and Get ( CurrentDate ) < DateReturned ; "On Leave" )
I lied, I didn't go to bed. If were in Dubai, I would buy you a beer. I can swear that I tried that combination. Does it make a difference if I use "&" instead of "and"?
Thank you and Happy New Year.
and and & are two different operators. And is the logical "and" that you need here. & is the concatenation operator used to "glue" chunks of text together into a single string.
Yes, "and" is a logical operator and it means that both conditions must be true to result to "true". "&" is the concatenating operator. It means that when you have two conditions that are true, it would result in "11", because "true" in FileMaker is represented by the value 1. In your situation this would mean, that if only one of your conditions would be true, then your Case () calculation would evaluate the true result, because it would be "10" or "01" (both considered true).
All this you can see in the data viewer, if you have FM Pro Advanced.